Howto: Determine the SQL 2000 Version

KB 321185 describes how to determine the version of SQL Server you are running. To determine which version of SQL you are running, enter the following into the SQL Query Analyzer:

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

The following table lists the Sqlservr.exe version number:

Release Sqlserver.exe
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.203

Notice SQL Server 2000 SP3 and SP3a have the same version of sqlserver.exe. SP3 is no longer available, and if you already have SP3 installed you do not need to apply SP3a. The changes made to SP3a were in the setup program, not in the actual Service Pack. There is a newer version of MDAC in SP3a, but you can download that separately.

Comments [1]

Leave a Reply

Your email address will not be published. Required fields are marked *