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
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cumulative Updates

Author  Topic 

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-07-16 : 09:47:41
How can I tell if a cumulative update has been applied to SQL Server? I have checked SERVERPROPERTY, but I have only seen ProductLevel, ProductVersion, and Edition for arguments.

Regards

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-16 : 09:58:05
If @@Version tells you Version is '10.5.1720.0' then it is SQL Server 2008 R2 CU2 for example.

See here:
http://www.sqlteam.com/article/sql-server-versions


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

dmaxj
Posting Yak Master

174 Posts

Posted - 2010-07-16 : 11:24:46
Thanks, webfred - that list is the best.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-07-16 : 11:27:26
welcome
But it is graz who is doing a good job


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -