The information in this article applies to:
SUMMARYThis article explains how to determine which service pack is installed on your SQL Server 6.x server. MORE INFORMATIONThere 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 1From 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:
Method 2Open 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:
Use the table in "Method 1" above to determine the service pack level. Method 3Using the SQL Query tool (ISQL or ISQL/w), execute the following query:
This should return results similar to the following:
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.
The ProductSuite key will have the following values depending on your product:
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 |
Last Reviewed: April 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |