Tuesday 13 October 2009

SQL Server versioning

SQL Server versions are:

Version Number
SQL Server version
2007.100.1600.0
SQL Server 2008 RTM
2007.100.2531.0
SQL Server 2008 Service Pack 1
2005.90.1399
SQL Server 2005 RTM
2005.90.2047
SQL Server 2005 Service Pack 1
2005.90.3042
SQL Server 2005 Service Pack 2
2005.90.4035
SQL Server 2005 Service Pack 3
2000.80.194.0
SQL Server 2000 RTM
2000.80.384.0
SQL Server 2000 SP1
2000.80.534.0
SQL Server 2000 SP2
2000.80.760.0
SQL Server 2000 SP3
2000.80.760.0
SQL Server 2000 SP3a
2000.8.00.2039
SQL Server 2000 SP4

See http://support.microsoft.com/kb/321185

To find the version of SQL Server try running the following SQL query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')