Article ID: 321185 - Last Review: April 8, 2009 - Revision: 13.0

How to identify your SQL Server version and edition

View products that this article applies to.
This article was previously published under Q321185

On This Page

Expand all | Collapse all

SUMMARY

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition of SQL Server you are using.
Back to the top

How to determine which version of SQL Server 2008 is running

To determine which version of Microsoft SQL Server 2008 is running, connect to SQL Server 2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement. 
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
  • The product version (for example, 10.0.1600.22)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise)
For example, the results resemble the following.
Collapse this tableExpand this table
10.0.1600.22RTMEnterprise Edition
The following table lists the Sqlservr.exe version number.
Collapse this tableExpand this table
ReleaseSqlservr.exe
RTM2007.100.1600.0
SQL Server 2008 Service Pack 12007.100.2531.0
Back to the top

How to determine which version of SQL Server 2005 is running

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement. 
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
  • The product version (for example, 9.00.1399.06)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise Edition)
For example, the results resemble the following.
Collapse this tableExpand this table
9.00.1399.06RTMEnterprise Edition
The following table lists the Sqlservr.exe version number.
Collapse this tableExpand this table
ReleaseSqlservr.exe
RTM2005.90.1399
SQL Server 2005 Service Pack 12005.90.2047
SQL Server 2005 Service Pack 22005.90.3042
SQL Server 2005 Service Pack 32005.90.4035
Back to the top

How to determine which version of SQL Server 2000 is running

To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code. 
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The following results are returned:
  • The product version (for example, 8.00.534)
  • The product level (for example, "RTM" or "SP2")
  • The edition (for example, "Standard Edition"). For example, the results resemble the following:

    8.00.534 SP2 Standard Edition
The following table lists the Sqlservr.exe version number.
Collapse this tableExpand this table
ReleaseSqlservr.exe
RTM2000.80.194.0
SQL Server 2000 SP12000.80.384.0
SQL Server 2000 SP22000.80.534.0
SQL Server 2000 SP32000.80.760.0
SQL Server 2000 SP3a2000.80.760.0
SQL Server 2000 SP42000.8.00.2039
Back to the top

How to determine which version of SQL Server 7.0 is running

To determine which version of SQL Server 7.0 is running, connect to SQL Server 7.0 by using Query Analyzer, and then run the following code. 
SELECT @@VERSION
The results resemble the following:
Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
        Nov 27 1998 22:20:07
        Copyright (c) 1988-1998 Microsoft Corporation
        Desktop Edition on Windows NT 5.1 (Build 2600: )
Note In this example, the version number is 7.00.623.

Use the version number in the following table to identify the product or service pack level.
Collapse this tableExpand this table
Version NumberService Pack
7.00.1063SQL Server 7.0 Service Pack 4 (SP4)
7.00.961SQL Server 7.0 Service Pack 3 (SP3)
7.00.842SQL Server 7.0 Service Pack 2 (SP2)
7.00.699SQL Server 7.0 Service Pack 1 (SP1)
7.00.623SQL Server 7.0 RTM (Release To Manufacturing)
If the version number that is reported by @@VERSION is not listed in this table, SQL Server is running with a hotfix or a security update build. For example, if @@VERSION reports a version number of 7.00.859, you are running SQL Server 7.0 SP2 with a hotfix installed. The version number increases with each new version of the Sqlservr.exe executable file. See to the Readme.txt file for your hotfix or security update for more information.
Back to the top

How to determine which version of SQL Server 6.5 is running

To determine which version of Microsoft SQL Server 6.5 is running, connect to SQL Server 6.5 by using Isql_w, and then run the following code. 
SELECT @@VERSION
Use the version number in the following table to identify the product or service pack level.
Collapse this tableExpand this table
Version NumberService Pack
6.50.479SQL Server 6.5 Service Pack 5a (SP5a) Update
6.50.416SQL Server 6.5 Service Pack 5a (SP5a)
6.50.415SQL Server 6.5 Service Pack 5 (SP5)
6.50.281SQL Server 6.5 Service Pack 4 (SP4)
6.50.258SQL Server 6.5 Service Pack 3 (SP3)
6.50.240SQL Server 6.5 Service Pack 2 (SP2)
6.50.213SQL Server 6.5 Service Pack 1 (SP1)
6.50.201SQL Server 6.5 RTM
If the version number that is reported by @@VERSION is not listed in this table, SQL Server is running with a hotfix or a security update build. The version number increases with each new version of the Sqlservr.exe executable file. See to the Readme.txt file for your hotfix or security update for more information.
Back to the top

How to determine which edition of SQL Server is running

If you are not sure about what edition of SQL Server that you are running, the last line of output that is returned by @@VERSION reports the edition to which you have connected. The example that is used in this article is the Standard Edition of SQL Server 2000 on Windows NT 5.0 (Build 2195: Service Pack 2).

Note The build and service pack information that is provided earlier is for the operating system, not for SQL Server.
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Back to the top

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
290211  (http://support.microsoft.com/kb/290211/ ) How to obtain the latest SQL Server 2000 service pack
301511  (http://support.microsoft.com/kb/301511/ ) How to obtain the latest SQL Server 7.0 service pack
273914  (http://support.microsoft.com/kb/273914/ ) Readme.txt for SQL Server 6.5 post-service pack 5a update
937137  (http://support.microsoft.com/kb/937137/ ) The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Express
Back to the top
Keywords: 
kbhowtomaster KB321185
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations