This article describes how to identify the current Microsoft SQL Server version number and the corresponding product or service pack level. This section also describes how to identify the SQL Server version in use.
How to determine which version of SQL Server 2008 is running
To determine which version of SQL Server 2008 is running, use SQL Server Management studio to connect to SQL Server 2008 and run the following statements.
Select Serverproperty ( ' Productversion ' ), Serverproperty ( ' Productlevel ' ), Serverproperty ( ' Edition ' )
The running result is as follows:
- Product Version (for example, 10.0.1600.22)
- Product level (for example, RTM)
- Version (for example, enterprise)
For example, the running result may be similar to the following content.
Collapse the table Expand the table
10.0.1600.22 |
RTM |
Enterprise Edition |
The following table lists the sqlservr.exe version numbers.
Collapse the table Expand the table
Version |
Sqlservr.exe |
RTM |
2007.100.1600.0 |
SQL Server 2008 Service Pack 1 |
2007.100.2531.0 |
How to determine which version of SQL Server 2005 is running
To determine the version of Microsoft SQL Server 2005 that is running, use SQL Server Management studio to connect to SQL Server 2005 and run the following statements.
Select Serverproperty ( ' Productversion ' ), Serverproperty ( ' Productlevel ' ), Serverproperty ( ' Edition ' )
The running result is as follows:
- Product Version (for example, 9.00.1399.06)
- Product level (for example, RTM)
- Version (for example, Enterprise Edition)
For example, the running result may be similar to the following content.
Collapse the table Expand the table
9.00.1399.06 |
RTM |
Enterprise Edition |
The following table lists the sqlservr.exe version numbers.
Collapse the table Expand the table
Release |
Sqlservr.exe |
RTM |
2005.90.1399 |
SQL Server 2005 Service Pack 1 |
2005.90.2047 |
SQL Server 2005 Service Pack 2 |
2005.90.3042 |
SQL Server 2005 Service Pack 3 |
2005.90.4035 |
How to determine which version of SQL Server 2000 is running
To determine the version of SQL Server 2000 that is running, use the query analyzer to connect to SQL Server 2000, and then run the followingCode.
Select Serverproperty ( ' Productversion ' ), Serverproperty ( ' Productlevel ' ), Serverproperty ( ' Edition ' )
The running result is as follows:
The following table lists the sqlservr.exe version numbers.
Collapse the table Expand the table
Release |
Sqlservr.exe |
RTM |
2000.80.194.0 |
Web SQL Server 2000 sp1 |
2000.80.384.0 |
Web SQL Server 2000 sp2 |
2000.80.534.0 |
Web SQL Server 2000 sp3 |
2000.80.760.0 |
SQL Server 2000 sp3a |
2000.80.760.0 |
Web SQL Server 2000 SP4 |
2000.8.00.2039 |
How to determine which version of SQL Server 7.0 is running
To determine the version of SQL Server 7.0 that is running, use the query analyzer to connect to SQL Server 7.0 and then run the following code.
Select @ Version
The result is similar to 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 the table Expand the table
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, patches are installed on the running SQL Server.ProgramOr securely update the internal version of the program. For example, if the @ Version Report version is 7.00.859, you are running SQL Server 7.0 SP2 with the patch installed. The version number increases with the new version of each sqlservr.exe executable file. For more information, see the readme.txt file for patches or security updates.