search cancel

How to find out what version, edition, and service pack of SQL Server is installed

book

Article ID: 151621

calendar_today

Updated On:

Products

Endpoint Encryption Endpoint Protection

Issue/Introduction

How to find out what version, edition, and service pack of SQL Server is installed?

Resolution

The following are five approaches to finding what version, edition, and service pack of SQL is currently installed on a machine.

The first four methods give you both edition and version whereas the fifth method only provides the version. All the methods except for method number five requires login to the SQL Server.

1. SQL Server Management Studio (SQL 2005)
      In Object Explorer, right-click a server, and then click Properties.








2. Enterprise Manager (SQL 2000)

      1. Open and log into the Enterprise Manager
      2. Expand a server group, and then right-click a server
      3. Click Properties.








3. SERVERPROPERTY Function

      SQL Server Edition and Version can be acquired using the SERVERPROPERTY function. This method can be used in both SQL Server 2000 and SQL Server 2005.


      The following is the T-SQL script that returns SQL Server version and edition:

        SELECT
          
        SERVERPROPERTY ('ProductVersion'),
          
        SERVERPROPERTY ('ProductLevel'),
          
        SERVERPROPERTY ('Edition')
        go







4. @@VERSION Variable

      SQL Server Edition and Version can be acquired using the global variable @@VERSION . This method can be used in both SQL Server 2000 and SQL Server 2005.


      The following is the T-SQL script that returns SQL Server version and edition:

        PRINT @@VERSION









5. SQLSERVER.EXE File Property

      The property page of SQLSERVER.EXE will show the SQL Server version.

      The file is located:

      \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn









SQL Server Version Number

      If you are unable to use the first two methods mentioned above, you would have to identify the version from product version. There is not a pattern to decode the version number to their relevant service pack update. Please find the equivalent with the version number using the following table.


      Version NumberService Pack
      90.00.3042.00SQL Server 2005 SP2
      90.00.2047.00SQL Server 2005 SP1
      90.00.1399.00SQL Server 2005 RTM
      8.00.2039SQL Server 2000 SP4
      8.00.760SQL Server 2000 SP3a
      8.00.760SQL Server 2000 SP3
      8.00.534SQL Server 2000 SP2
      8.00.384SQL Server 2000 SP1
      8.00.194SQL Server 2000 RTM
      7.00.1063SQL Server 7.0 SP4
      7.00.961SQL Server 7.0 SP3
      7.00.842SQL Server 7.0 SP2
      7.00.699SQL Server 7.0 SP1
      7.00.623SQL Server 7.0 RTM
      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


References
How to identify your SQL Server version and edition:


Attachments