导航

[转]SQL Server各版本版本号

Posted on 2013-03-20 10:09  FryFish  阅读(1294)  评论(0)    收藏  举报

转自：http://www.sqlteam.com/article/sql-server-versions

--------------------------------------------------------------------
I'm continually trying to track down what service packs are installed on various SQL Servers I support.  I can never find the right support page on Microsoft's site.  So here's an article with all the SQL Server version information I can track down.  If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.

 

Article Body

SQL Server 2012
11.0.2316         SQL Server 2012 CU1                    12 Apr 2012
11.0.2100.6 SQL Server 2012 RTM        7 Mar 2012
SQL Server 2008 R2
10.50.2811         SQL Server 2008 R2 SP1 CU6                    16 Apr 2012
10.50.2806         SQL Server 2008 R2 SP1 CU5                    22 Feb 2012
10.50.2796         SQL Server 2008 R2 SP1 CU4                    9 Jan 2012
10.50.2789.0         SQL Server 2008 R2 SP1 CU3                    17 Oct 2011
10.50.2772.0         SQL Server 2008 R2 SP1 CU2                    16 Aug 2011
10.50.2769.0         SQL Server 2008 R2 SP1 CU1                    16 Sep 2011
10.50.2500.0 SQL Server 2008 R2 SP1        11 Jul 2011
10.50.1815         SQL Server 2008 R2 CU13                    17 Apr 2012
10.50.1810         SQL Server 2008 R2 CU12                    21 Feb 2012
10.50.1809         SQL Server 2008 R2 CU11                    9 Jan 2012
10.50.1807.0         SQL Server 2008 R2 CU10                    19 Oct 2011
10.50.1804.0         SQL Server 2008 R2 CU9                    23 Aug 2011
10.50.1797.0         SQL Server 2008 R2 CU8                    16 Sep 2011
10.50.1777.0         SQL Server 2008 R2 CU7                    16 Jun 2011
10.50.1765.0         SQL Server 2008 R2 CU6                    21 Feb 2011
10.50.1753.0         SQL Server 2008 R2 CU5                    20 Dec 2010
10.50.1746.0         SQL Server 2008 R2 CU4                    18 Oct 2010
10.50.1734.0         SQL Server 2008 R2 CU3                    17 Aug 2010
10.50.1720.0         SQL Server 2008 R2 CU2                    25 Jun 2010
10.50.1702.0         SQL Server 2008 R2 CU1                    18 May 2010
10.50.1600.1 SQL Server 2008 R2 RTM        12 Apr 2010
SQL Server 2008
10.00.5775         SQL Server 2008 SP3 CU4                    20 Mar 2012
10.00.5770         SQL Server 2008 SP3 CU3                    16 Jan 2012
10.00.5768         SQL Server 2008 SP3 CU2                    22 Nov 2011
10.00.5766         SQL Server 2008 SP3 CU1                    18 Oct 2011
10.00.5500 SQL Server 2008 SP3        6 Oct 2011
10.00.4330         SQL Server 2008 SP2 CU9                    19 Mar 2012
10.00.4326         SQL Server 2008 SP2 CU8                    30 Jan 2012
10.00.4323         SQL Server 2008 SP2 CU7                    21 Nov 2011
10.00.4321         SQL Server 2008 SP2 CU6                    20 Sep 2011
10.00.4316         SQL Server 2008 SP2 CU5                    18 Jul 2011
10.00.4285         SQL Server 2008 SP2 CU4                    16 May 2011
10.00.4279         SQL Server 2008 SP2 CU3                    21 Mar 2011
10.00.4272         SQL Server 2008 SP2 CU2                    17 Jan 2011
10.00.4266         SQL Server 2008 SP2 CU1                    15 Nov 2010
10.00.4000 SQL Server 2008 SP2        29 Sep 2010
10.00.2850         SQL Server 2008 SP1 CU16                    19 Sep 2011
10.00.2847         SQL Server 2008 SP1 CU15                    18 Jul 2011
10.00.2816         SQL Server 2008 SP1 CU13                    22 Mar 2011
10.00.2812         SQL Server 2008 SP1 CU14                    16 May 2011
10.00.2808         SQL Server 2008 SP1 CU12                    17 Jan 2011
10.00.2804         SQL Server 2008 SP1 CU11                    15 Nov 2010
10.00.2799         SQL Server 2008 SP1 CU10                    21 Sep 2010
10.00.2789         SQL Server 2008 SP1 CU9                    19 Jul 2010
10.00.2775         SQL Server 2008 SP1 CU8                    17 May 2010
10.00.2766         SQL Server 2008 SP1 CU7                    15 Mar 2010
10.00.2757         SQL Server 2008 SP1 CU6                    18 Jan 2010
10.00.2746         SQL Server 2008 SP1 CU5                    24 Nov 2009
10.00.2734         SQL Server 2008 SP1 CU4                    22 Sep 2009
10.00.2723         SQL Server 2008 SP1 CU3                    21 Jul 2009
10.00.2714         SQL Server 2008 SP1 CU2                    18 May 2009
10.00.2710         SQL Server 2008 SP1 CU1                    16 Apr 2009
10.00.2531 SQL Server 2008 SP1        7 Apr 2009
10.00.1835         SQL Server 2008 RTM CU10                    15 Mar 2010
10.00.1828         SQL Server 2008 RTM CU9                    18 Jan 2009
10.00.1823         SQL Server 2008 RTM CU8                    16 Nov 2009
10.00.1818         SQL Server 2008 RTM CU7                    21 Sep 2009
10.00.1812         SQL Server 2008 RTM CU6                    21 Jul 2009
10.00.1806         SQL Server 2008 RTM CU5                    18 May 2009
10.00.1798         SQL Server 2008 RTM CU4                    17 Mar 2009
10.00.1787         SQL Server 2008 RTM CU3                    19 Jan 2009
10.00.1779         SQL Server 2008 RTM CU2                    17 Nov 2008
10.00.1763         SQL Server 2008 RTM CU1                    22 Sep 2008
10.00.1600 SQL Server 2008 RTM        6 Aug 2008
SQL Server 2005
9.00.5266         SQL Server 2005 SP4 CU3                    21 Mar 2011
9.00.5259         SQL Server 2005 SP4 CU2                    22 Feb 2011
9.00.5254         SQL Server 2005 SP4 CU1                    20 Dec 2010
9.00.5000 SQL Server 2005 SP4        17 Dec 2010
9.00.4325         SQL Server 2005 SP3 CU15                    21 Mar 2011
9.00.4317         SQL Server 2005 SP3 CU14                    21 Feb 2011
9.00.4315         SQL Server 2005 SP3 CU13                    20 Dec 2010
9.00.4311         SQL Server 2005 SP3 CU12                    18 Oct 2010
9.00.4309         SQL Server 2005 SP3 CU11                    17 Aug 2010
9.00.4305         SQL Server 2005 SP3 CU10                    23 Jun 2010
9.00.4294         SQL Server 2005 SP3 CU9                    19 Apr 2010
9.00.4285         SQL Server 2005 SP3 CU8                    16 Feb 2010
9.00.4273         SQL Server 2005 SP3 CU7                    21 Dec 2009
9.00.4266         SQL Server 2005 SP3 CU6                    19 Oct 2009
9.00.4230         SQL Server 2005 SP3 CU5                    17 Aug 2009
9.00.4226         SQL Server 2005 SP3 CU4                    16 Jun 2009
9.00.4220         SQL Server 2005 SP3 CU3                    21 Apr 2009
9.00.4211         SQL Server 2005 SP3 CU2                    17 Feb 2009
9.00.4207         SQL Server 2005 SP3 CU1                    20 Dec 2008
9.00.4053         SQL Server 2005 SP3 GDR (Security Update)                    13 Oct 2009
9.00.4035 SQL Server 2005 SP3        16 Dec 2008
9.00.3356         SQL Server 2005 SP2 CU17                    21 Dec 2009
9.00.3355         SQL Server 2005 SP2 CU16                    19 Oct 2009
9.00.3330         SQL Server 2005 SP2 CU15                    18 Aug 2009
9.00.3328         SQL Server 2005 SP2 CU14                    16 Jun 2009
9.00.3325         SQL Server 2005 SP2 CU13                    21 Apr 2009
9.00.3315         SQL Server 2005 SP2 CU12                    17 Feb 2009
9.00.3310         SQL Server 2005 SP2 Security Update                    10 Feb 2009
9.00.3301 SQL Server 2005 SP2 CU11            15 Dec 2008
9.00.3294         SQL Server 2005 SP2 CU10                    20 Oct 2008
9.00.3282         SQL Server 2005 SP2 CU9                    18 Aug 2008
9.00.3257         SQL Server 2005 SP2 CU8                    16 Jun 2008
9.00.3239         SQL Server 2005 SP2 CU7                    14 Apr 2008
9.00.3233 SQL Server 2005 QFE Security Hotfix            8 Jul 2008
9.00.3228         SQL Server 2005 SP2 CU6                    18 Feb 2008
9.00.3215         SQL Server 2005 SP2 CU5                    17 Dec 2007
9.00.3200         SQL Server 2005 SP2 CU4                    15 Oct 2007
9.00.3186         SQL Server 2005 SP2 CU3                    20 Aug 2007
9.00.3175         SQL Server 2005 SP2 CU2                    28 Jun 2007
9.00.3161 SQL Server 2005 SP2 CU1            15 Apr 2007
9.00.3152         SQL Server 2005 SP2 Cumulative Hotfix                    7 Mar 2007
9.00.3077         SQL Server 2005 Security Update                    10 Feb 2009
9.00.3054         SQL Server 2005 KB934458                    5 Apr 2007
9.00.3042.01 SQL Server 2005 "SP2a"        5 Mar 2007
9.00.3042 SQL Server 2005 SP2            1 Feb 2007
9.00.2047 SQL Server 2005 SP1         
9.00.1399 SQL Server 2005 RTM        1 Nov 2005
SQL Server 2000
8.00.2039 SQL Server 2000 SP4             
8.00.0760 SQL Server 2000 SP3             
8.00.0534 SQL Server 2000 SP2             
8.00.0384 SQL Server 2000 SP1             
8.00.0194 SQL Server 2000 RTM             
SQL Server 7
7.00.1063 SQL Server 7 SP4             
7.00.0961 SQL Server 7 SP3            15 Dec 2000
7.00.0842 SQL Server 7 SP2            20 Mar 2000
7.00.0699 SQL Server 7 SP1            15 Jul 1999
7.00.0623 SQL Server 7 RTM             
SQL Server 6.5
6.50.416 SQL Server 6.5 SP5a             
6.50.415 SQL Server 6.5 SP5             
6.50.281 SQL Server 6.5 SP4             
6.50.258 SQL Server 6.5 SP3             
6.50.240 SQL Server 6.5 SP2             
6.50.213 SQL Server 6.5 SP1             
6.50.201 SQL Server 6.5 RTM             

You can determine what version SQL Server is running by running

Select @@version

@@Version is a system level variable that holds the current version.  On my computer this returns

Microsoft SQL Server  2000 - 8.00.384 (Intel X86) 
	May 23 2001 00:02:52 
	Copyright (c) 1988-2000 Microsoft Corporation
	Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1.  See below for a complete list of versions.   It will also tell us the version of the operating system we're running.  In this case I'm running Windows 2000 (aka NT 5.0) Service Pack 2.   You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties.   The version information is displayed in the General tab.

This information is pulled from the system extended procedure xp_msver.  You can call this stored procedure like

exec master..xp_msver

and it returns

Index  Name                             Internal_Value Character_Value                     

------ -------------------------------- -------------- ------------------------------
1      ProductName                      NULL           Microsoft SQL Server
2      ProductVersion                   524288         8.00.384
3      Language                         1033           English (United States)
4      Platform                         NULL           NT INTEL X86
5      Comments                         NULL           NT INTEL X86
6      CompanyName                      NULL           Microsoft Corporation
7      FileDescription                  NULL           SQL Server Windows NT
8      FileVersion                      NULL           2000.080.0384.00
9      InternalName                     NULL           SQLSERVR
10     LegalCopyright                   NULL           © 1988-2000 Microsoft ...
11     LegalTrademarks                  NULL           Microsoft® is a registered ...
12     OriginalFilename                 NULL           SQLSERVR.EXE
13     PrivateBuild                     NULL           NULL
14     SpecialBuild                     25165824       NULL
15     WindowsVersion                   143851525      5.0 (2195)
16     ProcessorCount                   1              1
17     ProcessorActiveMask              1              00000001
18     ProcessorType                    586            PROCESSOR_INTEL_PENTIUM
19     PhysicalMemory                   255            255 (267902976)
20     Product ID                       NULL           NULL

This is quite a bit of additional information.  There really isn't anything  exciting in here that I can find but it's there if you need it.