Document ID: 25145
Updated: Sep 20, 2005
Contents
Introduction
This document explains how to determine the version of Microsoft SQL Server that is installed on your machine. Because the Microsoft SQL Server utilities provide only a build number, a build-number-to-service-pack translation table is included with the installation.
Prerequisites
Requirements
Cisco recommends that you have knowledge of these topics:
-
Microsoft SQL Server query utilities (ISQL_w for version 6.5, or Query Analyazer for version 7.0)
Components Used
The information in this document is based on these software and hardware versions:
-
Microsoft SQL Server version 6.5
-
Microsoft SQL Server version 7.0
-
Microsoft SQL Server 2000
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
Conventions
Refer to Cisco Technical Tips Conventions for more information on document conventions.
Determine the Version of Microsoft SQL Server
Run this query to determine the version of Microsoft SQL Server that is installed:
select @@version
This command returns results similar to this output:
Microsoft SQL Server 7.00 - 7.00.961 (Intel X86) Oct 24 2000 18:39:12 Copyright (c) 1988-1998 Microsoft Corporation Desktop Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
The first line indicates the base and full versions of Microsoft SQL Server. The full version of Microsoft SQL Server includes the build number. In this example, the base version is 7.00 and the full version is 7.00.961.
Translate the Build Number to a Service Pack
Use the tables in this section in order to match the build number with the appropriate service pack.
| Build Number | Service Pack Installed |
|---|---|
| 6.50.201 | No service pack installed |
| 6.50.213 | 1 |
| 6.50.240 | 2 |
| 6.50.258 | 3 |
| 6.50.281 | 4 |
| 6.50.415 | 5 |
| 6.50.416 | 5a |
| 6.50.479 | 5a Update |
| Build Number | Service Pack Installed |
|---|---|
| 7.00.623 | No service pack installed |
| 7.00.699 | 1 |
| 7.00.842 | 2 |
| 7.00.961 | 3 |
| 7.00.1063 | 4 |
| Build Number | Service Pack Installed |
|---|---|
| 8.00.194 or 2000.80.194.0 | No service pack installed |
| 8.00.384 or 2000.80.384.0 | 1 |
| 8.00.534 or 2000.80.534.0 | 2 |
| 8.00.760.03 or 2000.80.760.03 | 3 |
| 8.00.760.09 or 2000.80.760.09 | 3a |
Note: If the version number that is reported by @@version is not listed in this table, SQL Server is on a hotfix or security patch build.
Related Information
Open a Support Case 
(Requires a Cisco Service Contract.)
Related Cisco Support Community Discussions
The Cisco Support Community is a forum for you to ask and answer questions, share suggestions, and collaborate with your peers.
Refer to Cisco Technical Tips Conventions for information on conventions used in this document.