How to identify the version of SQL Server

How server determines which version of SQL Server 2005 is running

To determine the version of SQL Server 2005 that is running, use SQL Server Management Studio to connect to SQL Server 2005, and then run the following Transact-SQL statement: SELECT serverprop Erty (' ProductVersion '), serverproperty (' ProductLevel '), Serverproperty (' edition ')
The results are as follows: • Product version (for example, "9.00.1399.06").
• Product level (e.g., "RTM").
• Version (for example, "Enterprise Edition").
For example, the results of a run might resemble the following: 9.00.1399.06 RTM Enterprise Edition
The following table lists the version numbers for Sqlservr.exe:
Release version Sqlservr.exe
RTM 2005.9.00.1399

How to determine the version of SQL Server 2000 that is running

To determine the version of SQL Server 2000 that is running, use Query Analyzer to connect to SQL Server 2000, and then run the following code: SELECT serverproperty (' ProductVersion '), Serverproperty (' ProductLevel '), Serverproperty (' edition ')
The results of the operation are as follows: • Product version (e.g., 8.00.534).
• Product level (for example, "RTM" or "SP2").
• Version (for example, "Standard Edition"). For example, the results of a run might resemble the following:

8.00.534 RTM Standard Edition
The following table lists the version numbers for Sqlservr.exe:
Release version Sqlservr.exe
RTM 2000.80.194.0
SQL Server SP1 2000.80.384.0
SQL Server SP2 2000.80.534.0
SQL Server SP3 2000.80.760.0
SQL Server SP3a 2000.80.760.0
SQL Server SP4 2000.8.00.2039

How to determine the version of SQL Server 7.0 that is running

To determine the version of SQL Server 7.0 that is running, use Query Analyzer to connect to SQL Server 7.0, and then run the following code: SELECT @ @VERSION
The results of the run are similar to the following: Microsoft SQL server  7.00-7.00.623 (Intel X86)
Nov 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Deskt Op 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 level of the product level or Service Pack:
Version number Service Pack
7.00.1063 SQL Server 7.0 Service Pack 4 (SP4)
7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
7.00.623 SQL Server 7.0 RTM (Release to manufacturing)
If the version number of the @ @VERSION report is not listed in this table, the SQL Server that is running has either a hotfix or an internal version of the security update installed. For example, if the @ @VERSION report version number is 7.00.859, you are running the SQL Server 7.0 SP2 that has the hotfix installed. The version number of each new version of the Sqlservr.exe executable will increase. For more information, see the Readme.txt file for the hotfix or security update.

How to determine the version of SQL Server 6.5 that is running

To determine the version of SQL Server 6.5 that is running, use Isql_w to connect to SQL Server 6.5, and then run the following code: SELECT @ @VERSION
Use the version number in the following table to identify the level of the product level or Service Pack:
Version number Service Pack
6.50.479 SQL Server 6.5 Service Pack 5a (SP5A) Update
6.50.416 SQL Server 6.5 Service Pack 5a (SP5A)
6.50.415 SQL Server 6.5 Service Pack 5 (SP5)
6.50.281 SQL Server 6.5 Service Pack 4 (SP4)
6.50.258 SQL Server 6.5 Service Pack 3 (SP3)
6.50.240 SQL Server 6.5 Service Pack 2 (SP2)
6.50.213 SQL Server 6.5 Service Pack 1 (SP1)
6.50.201 SQL Server 6.5 RTM

If the version number of the @ @VERSION report is not listed in this table, the SQL Server that is running has either a hotfix or an internal version of the security update installed. The version number of each new version of the Sqlservr.exe executable will increase. For more information, see the Readme.txt file for the hotfix or security update.

How to determine the version of SQL Server that is running

If you are unsure of the version of SQL Server that is running, the last row in the output returned by @ @VERSION reports the version you are connecting to. The example used in this article is the SQL Server Standard Edition installed on Windows NT 5.0 (build 2195:service Pack 2). Service Pack 2)

Note: The build information and Service Pack information provided in the early stages are applicable to the operating system and are not available for SQL Server. Standard Edition on Windows NT 5.0 (build 2195:service Pack 2)