Data Management

Keeping track of service packs is easy with SQL Server

If you are a DBA in a big SQL Server database shop, keeping track of what service packs are on each SQL Server can become daunting. Here are a couple of scripts that help you determine what service pack you are running on a SQL Server. I am also including all the SQL Server product version numbers and a link for your pleasure.

  1. Open Query Analyzer and point to the Master database
  2. Type, select @@version and the product number will be displayed.

For more detail, perform the following:

  1. Open Query Analyzer and point to the Master database
  2. Type the following:

select serverproperty

('productversion'), serverproperty

('productlevel'), serverproperty

('edition')

In order to synchronize the version numbers with the correct service pack, see the Microsoft support article. To make things easier, here is a sample of some of the product version numbers.

  • SQL Server 2005 SP2-9.00.3042
  • SQL Server 2005 SP1-9.00.2047
  • SQL Server 2005 RTM-9.00.1399
  • SQL Server 2000 SP4-8.00.2039
  • SQL Server 2000 SP3a-8.00.760
  • SQL Server 2000 SP3-8.00.760
  • SQL Server 2000 SP2-8.00.534
  • SQL Server 2000 SP1-8.00.384
  • SQL Server 2000 RTM-8.00.194

Editor's Picks

Free Newsletters, In your Inbox