hi peter... i have a question about, how i can see if my sql server is the version 2005 sp2 and, what is the diference with server and server agent... i've checked the updates and the machine says i have up to date... but i dont know witch is.
thank you for your help
There are several ways to determine which version you are running. You can open a query window and type in "SELECT @.@.VERSION". This will return your version information. You can also go to Add/Remove Programs, click on your SQL 2005 entry, click on Remove and then Report. This will display a nice summary of what components/versions you are running on your machine.
Thanks,
Sam Lester (MSFT)
As for SQL Agent, it is a job scheduling service for SQL 2005. You can read about it here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/newsqlagent.mspx
No comments:
Post a Comment