Find out which version of SQL you are running

I recently encountered a problem where we had to identify the versions of SQL Running on a few servers. I found the quickest and easiest method was to run a SQL query against the servers in SQL Management studio. The SQL query to run is:

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

This will give you the version, service pack and edition. The SQL version numbers are listed below:

SQL Server 2005 RTM 2005.90.1399
SQL Server 2005 SP1 2005.90.2047
SQL Server 2005 SP1 plus 918222 2005.90.2153
SQL Server 2005 SP2 2005.90.3042
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
SQL2000 Reporting RTM 8.00.743.00
SQL2000 Reporting SP1 8.00.878.00
SQL2000 Reporting SP2 8.00.1038.00

Taken from http://support.microsoft.com/kb/321185