INF: How to Determine SQL Server 6.x Service Pack Installed

ID: Q202051

The information in this article applies to:

SUMMARY

This article explains how to determine which service pack is installed on your SQL Server 6.x server.


MORE INFORMATION

There are three ways to identify what service pack is running on the SQL Server: using SQL Enterprise Manager, the error logs, or the ISQL and ISQL/w query tools. Each method is described below.

Method 1

From SQL Enterprise Manager, right-click the SQL Server that you want to determine the service pack level for and click Configure on the shortcut menu. On the Server Configuration/Options box, click the Attributes tab. Compare the ProductVersion attribute with the following list:


ProductVersion Service Pack Level
6.00.121 6.0 No service pack installed
6.00.124 6.0 SP1
6.00.139 6.0 SP2
6.00.151 6.0 SP3
6.50.201 6.5 No service pack installed
6.50.213 6.5 SP1
6.50.240 6.5 SP2
6.50.258 6.5 SP3
6.50.281 6.5 SP4
6.50.415 6.5 SP5
6.50.416 6.5 SP5a

Method 2

Open any of the SQL Server error logs found in the MSSQL\Logs directory with a text editor such as Notepad. The first line of the log should be similar to the following: 

   98/10/19 10:26:21.74 kernel   Microsoft SQL Server  6.50 - 6.50.201
   (Intel X86) Apr  3 1996 02:55:53
   Copyright (c) 1988-1996 Microsoft Corporation

Use the table in "Method 1" above to determine the service pack level.

Method 3

Using the SQL Query tool (ISQL or ISQL/w), execute the following query: 

select @@version

This should return results similar to the following: 

   Microsoft SQL Server  6.50 - 6.50.201 (Intel X86)
   Apr  3 1996 02:55:53
   Copyright (c) 1988-1996 Microsoft Corporation
   (1 row(s) affected)

Use the table in "Method 1" above to determine the service pack level.

Note: The method described in this article only applies to standard SQL Server 6.x. Small Busines Server (SBS) and SQL 6.5 Enterprise Edition (EE) will not necessarily have the same version numbers. To determine if you are using SBS or EE you can view the following registry key.

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT or SQL Server to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk. 

   HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup\ProductSuite

The ProductSuite key will have the following values depending on your product:

Product Registry entry
SQL Server 6.x standard versions No entry (There should be NO ProductSuite key)
SQL 6.5 Enterprise Edition Enterprise
Small Business Server SBS


Also note that as of the publish date of this article, the current version number of EE is 6.50.258 and SBS is 6.50.259. For the most up to date version and service pack information please contact Microsoft Product Support Services.

Additional query words: sp errorlog errorlogs sms determining finding 


Keywords          : SSrvGen 
Version           : winnt:6.0,6.5
Platform          : winnt 
Issue type        : kbhowto kbinfo

Last Reviewed: April 13, 1999