How to identify the SQL Server Version and Edition?



This article applies to SQL 2000 and SQL 2005 only.

To check you SQL server version and edition, run the following query on the SQL instance:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

The results are:
- The product version (for example, 8.00.534).
- The product level (for example, "RTM" or "SP2").
- The edition (for example, "Standard Edition"). For example, the result looks similar to: "8.00.534 RTM Standard Edition"

Use the following table to identify your version:

  • Release Sqlservr.exe
    SQL Server 2000 RTM 2000.80.194.0
    SQL Server 2000 SP1 2000.80.384.0
    SQL Server 2000 SP2 2000.80.534.0
    SQL Server 2000 SP3 2000.80.760.0
    SQL Server 2000 SP3a 2000.80.760.0
    SQL Server 2000 SP4 2000.8.00.2039
    SQL Server 2005 RTM 2005.90.1399
    SQL Server 2005 Service Pack 1 2005.90.2047
    SQL Server 2005 Service Pack 2 2005.90.3042

"RTM" means that no Service Pack has been applied.

More Information

Last Revised: November 26, 2007
Applies To: SQL Server
All content © 1992-2007 Schneider Electric

Legacy KB System (APS) Data: RESL189707 V1.0, Originally authored by KBAdPM on 11/26/2007, Last Edited by KBAdPM on 11/26/2007
Related ranges: ION Enterprise V5.0, ION Enterprise V5.5, ION Enterprise V5.6