Monday, April 28, 2008

How to determine which service pack is installed with SQL 2005


  1. Open SQL Server Management Studio
  2. Click on 'New Query'
  3. Paste in SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
  4. Click on Execute
  5. The installed SP will display on the results tab
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)