Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SP2 or 3

Author  Topic 

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-08-27 : 11:01:42
We have SQL Server 2005 - how to know if its SP2 or SP3
?

I want to apply all latest patches.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-27 : 11:44:08
select @@version

Then compare against this list: http://www.sqlteam.com/article/sql-server-versions
Go to Top of Page
   

- Advertisement -