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.

Posted in howto. Tags: , , . 1 Comment »

One Response to “Howto: Determine the SQL 2000 Version”

  1. Making Groupwise 7 and Blackberry Enterprise Server Communicate « the back room tech Says:

    […] but this time the installer quit because we did not have at least SQL 2000 SP3a on the server. Determining which version of SQL 2000 is installed is not the easiest thing to do, so we just went ahead and downloaded and installed SQL 2000 […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: