How to find version of SQL Server 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 EditionThe 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 

sp_server_info gives set of SQL Server configuration information. Look for the attribute "DBMS_VER" to find the release.

Another way of finding the version is using "@@VERSION", its a system level variable which stores the versio.