SQL Server version

Source: Internet
Author: User
Tags microsoft sql server 2005 management studio sql server management sql server management studio

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.