Guest

Cisco Unified Intelligent Contact Management Enterprise

Determine What Microsoft SQL Server Service Pack is Installed

Document ID: 25145

Updated: Sep 20, 2005

   Print

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.

Table 1—Microsoft SQL Server 6.5

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

Table 2—Microsoft SQL Server 7.0

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

Table 3—Microsoft SQL Server 2000

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

Updated: Sep 20, 2005
Document ID: 25145