PSS ID Number: Q202051
Article Last Modified on 10-27-2000
The information in this article applies to:
-
Microsoft SQL Server 6.0, 6.5
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:
Issue Type: kbhowto kbinfo
Technology: kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ650