推荐订阅源

How to determine which version of SQL Server 2000 is running

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185

How to determine which version of SQL Server 2000 is running

To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code:

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	Sqlservr.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.2039