SQL Server version

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:

• Product Version (for example, 8.00.534)
• Product level (for example, "RTM" or "SP2 ")
• Version (for example, "Standard Edition "). For example, the running result may be similar to the following:

  8.00.534 SP2 Standard Edition

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.