This document explains how you can determine the Microsoft SQL Server
edition that is installed on your machine.
Readers of this document should be knowledgeable of the
The information in this document is based on the software and hardware
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.
For more information on document conventions, refer to
Technical Tips Conventions.
To determine the Microsoft SQL Server Edition that is currently running
on your machine, execute the following query from either ISQL_w or Query
Click Start > Programs >
Microsoft SQL Server.
Run Query Analyzer.
Note: ISQL w is for version 6.5 of SQL and this doc is for 7.0 or
This command returns results similar to the following:
Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Oct 24 2000 18:39:12
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
Note: The last line indicates the edition of Microsoft SQL Server that
is installed. In this example, the installed edition is the Standard
There are several editions of Microsoft SQL Server available, some of
which are noted here:
The following editions of Microsoft SQL Server are supported for use
with Cisco ICM:
Note: There is no benefit to running the Enterprise edition versus the
Standard edition with Cisco ICM.