Determine version of SQL server and Release Version Number

Some useful references:

Query to determine the version of a SQL 2000/2005/2008

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

SQL 2008 Release Revision:

  • SQL Server 2008 RTM – 2007.100.1600.0
  • SQL Server 2008 Service Pack 1 – 2007.100.2531.0

SQL 2005 Release Revision:

  • SQL Server 2005┬áRTM 2005.90.1399
  • SQL Server 2005 Service Pack 1 – 2005.90.2047
  • SQL Server 2005 Service Pack 2 – 2005.90.3042
  • SQL Server 2005 Service Pack 3 – z2005.90.4035

SQL 2000 Release Revision:

  • 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