SQL Server Version Number Information

SQL Server version numbers can provide information on what functionality, as well as resolved issues, are available in the build of SQL Server that has been installed. The following table provides a reference for the SQL Server version number, as well as the version label, for each addition of SQL Server. TechNet guidance on major version numbers is also available at the support site How to determine the version and edition of SQL Server and its components.

In SQL Server 2012 and SQL Server 2012 R2, use the following command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

In SQL Server 2008 and SQL Server 2008 R2, use the following command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

In SQL Server 2005, use the following command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

In SQL Server 2000, use the following command:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The latest versions of SQL Server patches and updates can be found on the Update Center for Microsoft SQL Server.

SQL Version Build # Date Released
7.0 RTM 7.00.623
7.0 SP1 7.00.699
7.0 SP2 7.00.842
7.0 SP3 7.00.961
7.0 SP4 7.00.1063
2000 8.00.194
2000 SP1 8.00.384
2000 SP2 8.00.532
2000 SP3 or 3a 8.00.760
2000 SP4 8.00.2039
2005 RTM 9.00.1399
2005 SP1 9.00.2047
2005 Rollup for SP1 9.00.2153
2005 SP2 9.00.3042
2005 GDR update to SP2 9.00.3150
2005 Cumulative Update 1 for SP2 9.00.3152
2005 Cumulative Update 2 for SP2 9.00.3175
2005 Cumulative Update 3 for SP2 9.00.3186
2005 Cumulative Update 4 for SP2 9.00.3200
2005 Cumulative Update 5 for SP2 9.00.3215
2005 SP3 9.00.4035
2005 SP4 9.00.5000
2008 RTM 10.00.1600
2008 Cumulative Update 10 10.00.1835
2008 SP1 10.00.2531
2008 Cumulative Update 1 for SP1 10.00.2710
2008 Cumulative Update 2 for SP1 10.00.2714
2008 Cumulative Update 3 for SP1 10.00.2723
2008 Cumulative Update 4 for SP1 10.00.2734
2008 Cumulative Update 5 for SP1 10.00.2746
2008 Cumulative Update 6 for SP1 10.00.2757
2008 Cumulative Update 7 for SP1 10.00.2766
2008 Cumulative Update 8 for SP1 10.00.2775
2008 Cumulative Update 9 for SP1 10.00.2789
2008 Cumulative Update 10 for SP1 10.00.2799
2008 Cumulative Update 11 for SP1 10.00.2804
2008 Cumulative Update 12 for SP1 10.00.2808
2008 SP2 10.00.4000
2008 Cumulative Update 1 for SP2 10.00.4266
2008 Cumulative Update 2 for SP2 10.00.4272
2008 Cumulative Update 3 for SP2 10.00.4285
2008 Cumulative Update 4 for SP2 10.00.4279 16-May-2011
2008 Cumulative Update 5 for SP2 10.00.4316 18-Jul-2011
2008 Cumulative Update 6 for SP2 10.00.4321 20-Sep-2011
2008 Cumulative Update 7 for SP2 10.00.4323 21-Nov-2011
2008 R2 RTM 10.50.1600
2008 R2 Cumulative Update 1 10.50.1702
2008 R2 Cumulative Update 2 10.50.1720
2008 R2 Cumulative Update 3 10.50.1734
2008 R2 Cumulative Update 4 10.50.1746
2008 R2 Cumulative Update 5 10.50.1753
2008 R2 Cumulative Update 6 10.50.1765
2008 R2 Cumulative Update 7 10.50.1777
2008 R2 SP1 10.50.2500 11-Jul-2011
2008 R2 SP1 Cumulative Update 1 10.50.2769 18-Jul-2011
2008 R2 SP1 Cumulative Update 2 10.50.2772 16-Aug-2011
2008 R2 SP1 Cumulative Update 3 10.50.2789 17-Oct-2011
2008 R2 SP1 Cumulative Update 4 10.50.2796 9-Jan-2012
2008 R2 SP1 Cumulative Update 5 10.50.2806 22-Feb-2012
2008 R2 SP1 Cumulative Update 6 10.50.2811 16-Apr-2012
2008 R2 SP2 10.50.4000 26-Jul-2012
2008 R2 SP2 Cumulative Update 1 10.50.4260 1-Aug-2012
2008 R2 SP2 Cumulative Update 3 10.50.4266 1-Aug-2012
Advertisements

2 Responses to “SQL Server Version Number Information”

  1. Kevin Bullen Says:

    Not to be picky, but the build # for 2008 Cumulative Update 10 for SP1 is 10.00.2799, not 10.00.2789 (that is the build number for Update 9).

    • gavinmckay Says:

      Thanks Kevin – more than happy for pickiness 🙂 I’ve updated the post. Copy-and-paste FAIL on my part.

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: