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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: