How to tell the current patch set level?

• grevesz

  Say Hey Kid

  Points: 672

  More actions

  June 10, 2008 at 9:41 am

  #192187

  Hello,

  I am learning SQL Server 2005.

  I understand that SP2 is available for this version.

  How can I tell if this service pack has already been applied?

  Thanks!

  Gabor

• Kyle Neier ,

  SSCrazy

  Points: 2252

  More actions

  June 10, 2008 at 10:14 am

  #826789

  You can read the good article here on this site:

  http://www.sqlservercentral.com/articles/Administration/2960/

  or you could read the Microsoft article

  http://support.microsoft.com/kb/321185

  Kyle

• grevesz

  Say Hey Kid

  Points: 672

  More actions

  June 10, 2008 at 12:41 pm

  #826899

  Kyle Neier (6/10/2008)

  ---

  You can read the good article here on this site:

  http://www.sqlservercentral.com/articles/Administration/2960/

  or you could read the Microsoft article

  http://support.microsoft.com/kb/321185

  Kyle

  Thanks!

  This helped me find the short answer that seems to work:

  SELECT SERVERPROPERTY('productlevel')

  Gabor