How to determine the version, edition and update level of SQL Server and its components

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Summary
This article describes how to determine your current Microsoft SQL Server version number and the corresponding servicing or service pack level. It also describes how to determine the specific edition of SQL Server that you are using.

Notes

  • A downloadable version of an Excel workbook that contains all the build versions together with their current support life cycle stage for 2005 through the current version is available. Click to download this Excel file now. (File name: SQL Server Builds V3.xlsx)
  • SQL script to report version, edition, and servicing level: The Microsoft OneScript team has released a script to run in SQL Server Management Studio that can be used to determine the following:

    • Major version, servicing level, and edition of SQL Server
    • Latest updates available for your version
    • Servicing support life cycle stage
    For more information about this script, see Determining the version and edition of SQL Server and its components in TechNet Gallery.
  • To learn what a specific version number of SQL Server maps to, or to find the KB article information for a specific cumulative update package or a service pack, search for the version number in the SQL Server Complete Version list table.
  • To find the edition of your SQL Server instance, you can use one of the procedures in Method 2 through Method 5 in the "How to determine which version and edition of SQL Server Database Engine is running" section.

    Note The version information and edition information are in the same output string.
  • Latest updates available for currently supported versions of SQL Server

    Note For information about SQL Server Support life cycle, check the Microsoft SQL Server support lifecycle page.

    Table 1: Latest updates available for each SQL Server version

    VersionMost recent service pack Latest cumulative updateComplete version information
    SQL Server 2016SQL Server 2016 SP1 (13.0.4001.0 – November 2016CU3 for 2016 RTM (13.0.2186.6 – November 2016)SQL Server 2016 builds
    SQL Server 2014SQL Server 2014 SP2 (12.0.5000.0 – July 2016)CU2 for 2014 SP2 (12.0.5522.0 – October 2016)
    CU9 for 2014 SP1 (12.0.4474.0 –October 2016)
    SQL Server 2014 builds
    SQL Server 2012SQL Server 2012 SP3 (11.0.6020.0 – November 2015)

    CU6 for 2012 SP3 (11.0.6567.0 – November 2016)

    CU15 for 2012 SP2 (11.0.5676.0 –September 2016)

    CU16 for 2012 SP1 (11.0.3487.0 - May 2015)
    SQL Server 2012 builds
    SQL Server 2008 R2SQL Server 2008 R2 SP3 (10.50.6000.34 – September 2014)

    Note Latest and final release for this version
    NoneSQL Server 2008 R2 builds
    SQL Server 2008SQL Server 2008 SP4 (10.0.6000.29 – September 2014)

    Note Latest and final release for this version
    NoneSQL Server 2008 builds
    SQL Server 2005SQL Server 2005 SP4 (9.00.5000.00 – December 2010)NoneSQL Server 2005 builds
    Note "Latest" = During the past 12 months.

    Table 2: Where to find more information about each version

    VersionService Pack informationCumulative update information
    SQL Server 20163177534 How to obtain the latest service pack for SQL Server 20163177312 Latest cumulative update for SQL Server 2016
    SQL Server 20142958069 How to obtain the latest service pack for SQL Server 20142936603 SQL Server 2014 build versions
    SQL Server 20122755533 How to obtain the latest service pack for SQL Server 2012

    2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released

    2983249 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 2 was released

    3133750 SQL Server 2012 SP3 build versions
    SQL Server 2008 R22527041 How to obtain the latest service pack for SQL Server 2008 R2981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

    2567616 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 1 was released

    2730301 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 Service Pack 2 was released
    SQL Server 2008968382 How to obtain the latest service pack for SQL Server 2008956909 The SQL Server 2008 builds that were released after SQL Server 2008 was released

    970365 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

    2402659 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released

    2629969 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 3 was released
    SQL Server 2005913089 How to obtain the latest service pack for SQL Server 2005

    937137 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

    960598 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released

    2485757 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 4 was released

How to determine which version and edition of SQL Server Database Engine is running

To determine the version of SQL Server, you can use any of the following methods.

Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.

Method 2: Look at the first few lines of the Errorlog file for that instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files. The entries may resemble the following:

2011-03-27 22:31:33.50 Server      Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)                March 29 2009 10:11:52                Copyright (c) 1988-2008 Microsoft CorporationExpress Edition (64-bit)on Windows NT 6.1 <X64> (Build 7600: )
This entry provides all the necessary information about the product, such as version, product level, 64-bit versus 32-bit, the edition of SQL Server, and the OS version on which SQL Server is running.

Note The output of this query has been enhanced to show additional information, as documented in the blog post article, What build of SQL Server are you using?, for the following versions:

  • SQL Server 2014 RTM CU10 and later versions
  • SQL Server 2014 Service Pack 1 CU3 and later versions
  • SQL Server 2012 Service Pack 2 CU7 and later versions

Method 3: Connect to the instance of SQL Server, and then run the following query:

Select @@version
An example of the output of this query is as follows:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)  March 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft CorporationExpress Edition (64-bit)  on Windows NT 6.1 <X64> (Build 7600: )


Note The output of this query has been enhanced to show additional information. This is documented in the blog post article, What build of SQL Server are you using?, for the following versions:

  • SQL Server 2014 RTM CU10 and later versions
  • SQL Server 2014 Service Pack 1 CU3 and later versions
  • SQL Server 2012 Service Pack 2 CU7 and later versions

    Example of changed output

Method 4: Connect to the instance of SQL Server, and then run the following query in SQL Server Management Studio (SSMS):

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),SERVERPROPERTY ('edition')
Note This query works with any instance of SQL Server 2000 or a later version.

The following results are returned:

  • The product version (for example, 10.0.1600.22)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise)

For example, the results resemble the following.

10.0.1600.22RTMEnterprise Edition

Notes


  • The SERVERPROPERTY function returns individual properties that relate to the version information, although the @@VERSIONfunction combines the output into one string. If your application requires individual property strings, you can use the SERVERPROPERTY function to return them instead of parsing the @@VERSIONresults.
  • This method also works for SQL Azure Database instances. For additional information refer to the following topic in SQL Server Books Online SERVERPROPERTY (Transact-SQL).
  • Starting with SQL Server 2014 RTM Cumulative Update 10 and SQL Server 2014 Service Pack 1 Cumulative Update 3, additional properties have been added to ServerProperty statement as noted in the following table.

    ProductBuildType Type of build of the current build.

    Returns one of the following:

    • OD = OD released to the web for a particular customer
    • GDR = GDR released through windows update
    • NULL = Not applicable
    ProductLevelLevel of the version of the instance of SQL Server.

    Returns one of the following:

    • 'RTM' = Original release version
    • 'SPn' = Service pack version
    • 'CTPn', = Community Technology Preview version
    ProductUpdateLevelUpdate level of the current build.

    Returns one of the following:

    • CUn = Cumulative Update
    • NULL = Not applicable
    ProductUpdateReference KB article for that release
    ProductBuild The build number
    ProductMajorVersion The major version
    ProductMinorVersion The minor version
    InstanceDefaultDataPathThis is default location where the data files for any database in this instance will be created. This value is specified in the Data Directories tab or /SQLUSERDBDIR parameter during setup.
    InstanceDefaultLogPathThis is default location where the log files for any database in this instance will be created. This value is specified in the Data Directories tab or /SQLUSERDBLOGDIR parameter during setup.
    Example output:
    SELECTSERVERPROPERTY('ProductLevel') AS ProductLevel,SERVERPROPERTY('ProductUpdateLevel') AS ProductUpdateLevel,SERVERPROPERTY('ProductBuildType') AS ProductBuildType,SERVERPROPERTY('ProductUpdateReference') AS ProductUpdateReference,SERVERPROPERTY('ProductVersion') AS ProductVersion,SERVERPROPERTY('ProductMajorVersion') AS ProductMajorVersion,SERVERPROPERTY('ProductMinorVersion') AS ProductMinorVersion,SERVERPROPERTY('ProductBuild') AS ProductBuildGO
    ProductLevelProductUpdateLevelProductBuildTypeProductUpdateReferenceProductVersionProductMajorVersionProductMinorVersionProductBuild
    SP1CU3NULLKB309422112.0.4425.191204425

Method 5: Starting with SQL Server 2008, you can also use the Installed SQL Server Features Discovery report. This report can be found by locating the Tools page of SQL Server Installation Center. This tool gives information about all the instances of SQL Server that are installed on the system. These include client tools such as SQL Server Management Studio. The only thing to be aware of is that this tool can be run locally only on the system where SQL server is installed. It cannot be used to obtain information about remote servers. For more information, visit the following blog post on the Microsoft Developer Network (MSDN): A snapshot of a sample report is as follows:

The screen shot showing a sample report

How to determine the version of SQL Server Client tools

SQL Server Management Studio (SSMS)

To determine the version of the client tools that are installed on your system, start Management Studio, and then click About on the Help menu. (See the following screen shot.)

About SSMS


SQL Server Business Intelligence Development Studio (BIDS)

To check the version of Analysis Services Designer, of Integration Services Designer, or of SQL Server Reporting Services Designer, follow these steps:

  1. Under your SQL program group, start SQL Server Business Intelligence Development Studio.
  2. On the Help menu, click About.
  3. In the Installed products list, select the required component, and then notice the version that is given in the Product details text box.
    (See the following screen shots.)

SQL Server 2005 / Visual Studio 2005

SQLServer2005&VS2005


SQL Server 2008 / SQL Server 2008 R2 / Visual Studio 2008

SQLServer2008&VS2008

Note For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.

SQL Server Reporting Services

To determine the version of SQL Server Reporting Services, refer to the following topic in SQL Server Books Online:

SQL Server Integration Services

To determine the version of SQL Server Integration Services, refer to the following article in the Microsoft Knowledge Base:
942177 How to determine the version of SQL Server Integration Services

SQL Server Analysis Services

To determine the version of SQL Server Analysis Services, use one of the following methods:

Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of Analysis Services.

Method 2: Check the version of the Msmdsrv.exe file in the Analysis Services bin folder. The default locations are shown in the following table.

Analysis Services versionLocation
2008 R2C:\Program Files\Microsoft SQL Server\MSAS10_50.InstanceName\OLAP\bin\MsMdSrv.exe
2008C:\Program Files\Microsoft SQL Server\MSAS10.InstanceName\OLAP\bin\MsMdSrv.exe
2005C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\Bin\MsMdSrv.exe
2000C:\Program Files\Microsoft Analysis Services\Bin\MsMdSrv.exe

Method 3: Use the registry keys that are listed in the following table.

Analysis Services versionLocation
2008 R2HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \MSSQLServer\CurrentVersion Key: CurrentVersion

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.InstanceName \Setup Keys: PatchLevel , Version, Key Edition
2008HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.InstanceName\MSSQLServer\CurrentVersion Key: CurrentVersion

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.InstanceName \Setup\ Keys: PatchLevel, Version, Edition
2005HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\CurrentVersion Key: CurrentVersoin

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\Setup Keys: PatchLevel, Version, Edition
2000HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion Key: CSDVersion

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\Setup Key: PatchLevel

For more information, visit the following Microsoft TechNet blog post:

SQL Server replication

Because replication agents may be installed on several different computers, it is important to check the installed versions on all affected computers.

For example, the Distribution Agent in Transactional or Peer-to-Peer replication may exist on computers that differ from the publisher instance of SQL Server and may exist on the various subscriber instances of SQL Server in a pull subscription.

If you use Web Synchronization for Merge Replication or SQL Server 2000 Windows CE Edition replication, the IIS web server may not be the same computer as the computer that is running SQL Server. Therefore, you have replication agent files that are installed on the IIS web server. And you may have to check the version of those .dll files in the IIS virtual directory and update them explicitly to obtain the latest service packs, cumulative updates, and hotfixes for your web agents.

For more information, see the following topic in SQL Server Books Online:

Full-text search

Full-text search components include the following:

  • Sqlserver.exe
  • Sql_fulltext_keyfile.dll
  • Iftsph.dll
  • Fd.dll
  • Fdhost.exe
  • Fdlauncher.exe
Except for Sqlservr.exe, these components may not be updated with each cumulative update or service pack for the respective SQL Server product. The versions of these files will change only when there is a fix to the respective component. Generally, you can check the file version of each of these .dll files. The highest version in the list is the version of the full-text search component that is installed on the system.

You can use one of the following methods to determine the version of the full-text search component that is installed on your system.

Note Each of these methods may indicate that the version of the full-text search compnent is either RTM or a version that is earlier than the current version of the database component. We acknowledge that this is a problem and are working on fixing it in a future update.

Method 1: Check the version of SQL Server Full-Text Key (Sql_fulltext_keyfile.dll) in the SQL Server 2008 R2 or SQL Server 2008 installation folder. Typically, for SQL Server 2008 R2, this file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\MSQL10_50.<Instance Name>\MSSQL

For SQL Server 2008, this file typically is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\MSQL10.<Instance Name>\MSSQL

Method 2: Check the following registry subkey:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft sql server\Mssql10_50.instname\Setup\SQL_FULLTEXT_ADV
An example entry at this registry key is the following:

featurelist:  SQL_FullText_Adv=3 SQL_FullText_CNI=3ProductCode:  {9DFA5914-C275-42E0-810E-C88E46A7F9EA}Patchlevel:   10.50.1765.0Version:      10.50.1600.1
In this example entry, the third line (Patchlevel) indicates the current build of full-text search component that is installed, and the fourth line (Version) usually shows the original version of full-text search that is installed. In this case, it is SQL Server 2008 R2.

Method 3: Use the Summary.txt file that is created during setup. For SQL Server 2008 R2, this file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\LOG\Summary.txt

For SQL Server 2008, this file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt
See the following article in the Microsoft Knowledge Base for a known issue that uses full-text search components in SQL Server 2008 installations:
973888 The Full-Text Search component is not completely rolled back to the Service Pack 1 version after you uninstall Cumulative Update 3 for SQL Server 2008 Service Pack 1 that is applied by using a slipstream installation

SQL Server Master Data Services (MDS)

The MDS Configuration Manager does not show the currently installed version number directly.

Be aware that MDS has a unique versioning scenario in which the SQL Server database engine installation does not necessarily match the MDS version. The version may vary when you compare the SQL Server installation to the binaries deployed in the MDS website and the MDS catalog schema version. Manual steps that use the MDS Configuration Manager tool are required to update and to upgrade the MDS websites and database schemas. You can refer to the following blog post on hotfix and service pack update methodology for MDS:

The following registry key shows the binary versions that are installed on the SQL Server. However, this version does not necessarily match the website and database schema version until the MDS upgrade process is complete.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Master Data Services 10.5\CurrentVersion

You can check the installed product version and schema version by using the following query in the MDS catalog:

select * from mds.mdm.tblSystem

SQL Server Native Client

Note The major SQL Server version of latest SQL Server Native Client is SQL Server 2012. It’s compatible with SQL Server 2014.

To determine the version of SQL Server Native Client, use one of the following methods:

Method 1: On the system where you want to find the version of Native Client, start the ODBC Administrator (odbcad32.exe), and then check the Version column under the Drivers tab.

Method 2: Check the following PatchLevel or Version keys at the following registry locations.

SQL version /
SQL Server Native Client version
Registry keys
SQL Server 2008 R2
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL Server 2008 /
SQL Server Native Client 10
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion
SQL Server 2005 /
SQL Server Native Client 9
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion
SQL Server 2012HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI11\CurrentVersion
SQL Server 2014HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI11\CurrentVersion

SQL Server Browser

The browser version should match the highest version of the SQL Server Database Engine and of the instances of Analysis Services that are installed on the computer.

SQL Server Writer

To determine the version of SQL Server Writer, check the following registry key value:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SqlWriter\CurrentVersion
Keys: PatchLevel or Version

The Microsoft .NET Framework

To determine the version of the .NET Framework on your system, refer to the following article in the Microsoft Knowledge Base:
318785 How to determine which versions and service pack levels of the Microsoft .NET Framework are installed
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2027770 Understanding the .NET Framework requirements for various versions of SQL Server

SQL Azure

To find the version of your instance of SQL Azure and related information, see the following topic in Books Online:

SQL Server CE

To find the version of your instance of SQL Server CE and related information, see the following resources:

More information

Frequently asked questions

Q1: How do you determine the version of SQL Server when SQL Server is not running?

A1: You can determine the version of SQL Server by using either Method 2 or Method 5 (for SQL Server 2008 or later versions) in the "How to determine which version and edition of SQL Server Database Engine is running" section of this article.

Q2: How do I map the product versions to product names?

A2: You can use the following table as a reference.

Version patternSQL Product
12.0.x.xSQL Server 2014
11.0.x.xSQL Server 2012
10.50.x.xSQL Server 2008 R2
10.00.x.xSQL Server 2008
9.00.x.xSQL Server 2005
8.00.x.xSQL Server 2000

Frequently used terms and acronyms

Cumulative update (CU): A roll-up update that contains all previous critical on-demand hotfixes to date. Additionally, a CU contains fixes for issues that meet the hotfix acceptance criteria. These criteria may include the availability of a workaround, the effect on the customer, the reproducibility of the problem, the complexity of the code that must be changed, and other topics.

Hotfix: A single, cumulative package that includes one or more files that are used to address a problem in a product and are cumulative at the binary and file level. A hotfix addresses a specific customer situation and may not be distributed outside the customer's organization.

RTM: Usually means "release to manufacturing." In the context of a product such as SQL Server, it indicates that no service packs or hotfixes were applied to the product.

RTW: Usually means "release to web." It indicates a package that was released to the web and made available to customers for downloading.

Service pack: A tested, cumulative set of all hotfixes, security updates, critical updates, and updates. Service packs may also contain additional fixes for problems that are found internally since the release of the product and a limited number of customer-requested design changes or features.

For more information, visit the following websites:

SQL Server complete version list table

Note These tables use the following format and are ordered by the build number.

Build number or versionService PackUpdateKB ArticleRelease date

SQL Server 2016

Build number or versionService PackUpdateKB ArticleRelease date
13.0.4001.0SP1RTW/PCU13182545November 16, 2016
13.0.2186.6RTMCU33205413November 16, 2016
13.0.2164.0 RTMCU23182270September 22, 2016
13.0.2149.0RTM CU13164674July 25, 2016

SQL Server 2014

Build number or versionService PackUpdateKB ArticleRelease date
12.0.5522.0SP2CU23188778October 17, 2016
12.0.5511.0SP2CU13178925August 25, 2016
12.0.5000.0SP2 RTW/PCU23171021July 11, 2016
12.0.4474.0SP1CU93186964October 17, 2016
12.0.4468.0SP1CU8 3174038August 15, 2016
12.0.4459.0SP1CU73162659June 20, 2016
12.0.4457.0SP1CU63167392May 30,2016
12.0.4449.0SP1CU63144524April 18, 2016
12.0.4438.0SP1CU53130926February 22, 2016
12.0.4436.0SP1CU43106660December 21, 2015
12.0.4427.24SP1CU33094221October 19, 2015
12.0.4422.0SP1CU23075950August 17, 2015
12.0.4416.0SP1CU13067839June 19, 2015
12.0.4213.0SP1MS15-058: GDR Security Update3070446July 14, 2015
12.0.4100.1SP1RTW/PCU13058865May 04, 2015
12.0.2569.0 RTMCU143158271June 20, 2016
12.0.2568.0RTMCU133144517April 18, 2016
12.0.2564.0RTMCU123130923February 22, 2016
12.0.2560.0RTMCU113106659December 21, 2015
12.0.2556.4RTMCU103094220October 19, 2015
12.0.2553.0RTMCU93075949August 17, 2015
12.0.2548.0RTMMS15-058: QFE Security Update3045323July 14, 2015
12.0.2546.0RTMCU83067836June 19, 2015
12.0.2495.0RTMCU73046038April 20, 2015
12.0.2480.0RTMCU63031047February 16, 2015
12.0.2456.0RTMCU53011055December 17, 2014
12.0.2430.0RTMCU42999197October 21, 2014
12.0.2402.0RTMCU32984923August 18, 2014
12.0.2381.0RTMMS14-044: QFE Security Update2977316August 12, 2014
12.0.2370.0RTMCU22967546Friday, June 27, 2014
12.0.2342.0RTMCU12931693April 21, 2014
12.0.2269.0RTMMS15-058: GDR Security Update 3045324July 14, 2015
12.0.2254.0RTMMS14-044: GDR Security Update2977315August 12, 2014
12.0.2000.8RTMApril 01, 2014

SQL Server 2012

Build number or versionService PackUpdateKB ArticleRelease date
11.0.6567.0 SP3CU63194992November 17, 2016
11.0.6544.0SP3CU53180915September 19, 2016
11.0.6540.0SP3CU43165264July 18, 2016
11.0.6537.0SP3CU33152635May 16, 2016
11.0.6523.0SP3CU23137746March 21,2016
11.0.6518.0SP3CU13123299January 19, 2016
11.0.6020.0SP3RTW/PCU33072779November 20, 2015
11.0.5676.0SP2CU153205416November 17, 2016
11.0.5657.0SP2CU143180914September 19, 2016
11.0.5655.0SP2CU133165266July 18, 2016
11.0.5649.0SP2CU123152637May 16, 2016
11.0.5646.0SP2CU113137745March 21,2016
11.0.5644.2SP2CU103120313January 19, 2016
11.0.5641.0SP2CU93098512November 16, 2015
11.0.5634.1SP2CU83082561September 21, 2015
11.0.5623.0SP2CU73072100July 20, 2015
11.0.5613.0SP2MS15-058: QFE Security Update3045319July 14, 2015
11.0.5592.0SP2CU63052468May 18, 2015
11.0.5582.0SP2CU53037255March 16, 2015
11.0.5569.0SP2CU43007556January 19, 2015
11.0.5556.0SP2CU33002049November 17, 2014
11.0.5548.0SP2CU22983175September 15, 2014
11.0.5532.0SP2CU12976982July 23, 2014
11.0.5343.0SP2MS15-058: GDR Security Update3045321July 14, 2015
11.0.5058.0SP2RTW/PCU22958429June 10, 2014
11.0.3513.0SP1MS15-058: QFE Security Update3045317July 14, 2015
11.0.3482.00SP1CU133002044November 17, 2014
11.0.3470.00SP1CU122991533September 15, 2014
11.0.3460.0SP1MS14-044: QFE Security Update 2977325August 12, 2014
11.0.3449.00SP1CU112975396July 21, 2014
11.0.3431.00SP1CU102954099May 19, 2014
11.0.3412.00SP1CU92931078March 17, 2014
11.0.3401.00SP1CU82917531January 20, 2014
11.0.3393.00SP1CU72894115November 18, 2013
11.0.3381.00SP1CU62874879September 16, 2013
11.0.3373.00SP1CU52861107July 15, 2013
11.0.3368.00SP1CU42833645May 30, 2013
11.0.3349.00SP1CU32812412March 18, 2013
11.0.3339.00SP1CU22790947January 21, 2013
11.0.3321.00SP1CU12765331November 20, 2012
11.0.3156.00SP1MS15-058: GDR Security Update3045318July 14, 2015
11.0.3153.00SP1MS14-044: GDR Security Update2977326August 12, 2014
11.0.3000.00SP1RTW/PCU12674319November 7, 2012
11.0.2424.00RTMCU112908007December 16, 2013
11.0.2420.00RTMCU102891666October 21, 2013
11.0.2419.00RTMCU92867319August 20, 2013
11.0.2410.00RTMCU82844205June 17, 2013
11.0.2405.00RTMCU72823247April 15, 2013
11.0.2401.00RTMCU62728897February 18, 2013
11.0.2395.00RTMCU52777772December 17, 2012
11.0.2383.00RTMCU42758687October 15, 2012
11.0.2376.00RTMMS12-070: QFE Security Update2716441October 9, 2012
11.0.2332.00RTMCU32723749August 31, 2012
11.0.2325.00RTMCU22703275June 18, 2012
11.0.2316.00RTMCU12679368April 12, 2012
11.0.2218.00RTMMS12-070: GDR Security Update2716442October 9, 2012
11.0.2100.60RTMMarch 6, 2012

SQL Server 2008 R2

Build number or versionService PackUpdateKB ArticleRelease date
10.50.6529.00SP3MS15-058: QFE Security Update3045314July 14, 2015
10.50.6220.00SP3MS15-058: QFE Security Update3045316July 14, 2015
10.50.6000.34SP3RTW/PCU32979597September 26, 2014
10.50.4339.00SP2MS15-058: QFE Security Update3045312July 14, 2015
10.50.4321.00SP2MS14-044: QFE Security Update2977319August 14, 2014
10.50.4319.00SP2CU132967540June 30, 2014
10.50.4305.00SP2CU122938478April 21, 2014
10.50.4302.00SP2CU112926028February 18, 2014
10.50.4297.00SP2CU102908087December 17, 2013
10.50.4295.00SP2CU92887606October 28, 2013
10.50.4290.00SP2CU82871401August 22, 2013
10.50.4285.00SP2CU72844090June 17, 2013
10.50.4279.00SP2CU62830140April 15, 2013
10.50.4276.00SP2CU52797460February 18, 2013
10.50.4270.00SP2CU42777358December 17, 2012
10.50.4266.00SP2CU32754552October 15, 2012
10.50.4263.00SP2CU22740411August 31, 2012
10.50.4260.00SP2CU12720425July 24, 2012
10.50.4042.00SP2MS15-058: GDR Security Update3045313July 14, 2015
10.50.4033.00SP2MS14-044: GDR Security Update2977320August 12, 2014
10.50.4000.0SP2RTW/PCU22630458July 26, 2012
10.50.2881.00SP1CU142868244August 8, 2013
10.50.2876.00SP1CU132855792June 17, 2013
10.50.2874.00SP1CU122828727April 15, 2013
10.50.2869.00SP1CU112812683February 18, 2013
10.50.2868.00SP1CU102783135December 17, 2012
10.50.2866.00SP1CU92756574October 15, 2012
10.50.2861.00SP1MS12-070: QFE Security Update2716439October 9, 2012
10.50.2822.00SP1CU82723743August 31, 2012
10.50.2817.00SP1CU72703282June 18, 2012
10.50.2811.00SP1CU62679367April 16, 2012
10.50.2806.00SP1CU52659694February 22, 2012
10.50.2796.00SP1CU42633146December 19, 2011
10.50.2789.00SP1CU32591748October 17, 2011
10.50.2772.00SP1CU22567714August 15, 2011
10.50.2769.00SP1CU12544793July 18, 2011
10.50.2550.00SP1MS12-070: GDR Security Update2754849October 9, 2012
10.50.2500.0SP1RTW/PCU12528583July 12, 2011
10.50.1815.00RTMCU132679366April 16, 2012
10.50.1810.00RTMCU122659692February 21, 2012
10.50.1809.00RTMCU112633145December 19, 2011
10.50.1807.00RTMCU102591746October 17, 2011
10.50.1804.00RTMCU92567713August 15, 2011
10.50.1797.00RTMCU82534352June 20, 2011
10.50.1790.00RTMMS11-049: QFE Security Update2494086June 14, 2011
10.50.1777.00RTMCU72507770April 18, 2011
10.50.1765.00RTMCU62489376February 21, 2011
10.50.1753.00RTMCU52438347December 20, 2010
10.50.1746.00RTMCU42345451October 18, 2010
10.50.1734.00RTMCU32261464August 16, 2010
10.50.1720.00RTMCU22072493June 21, 2010
10.50.1702.00RTMCU1981355May 18, 2010
10.50.1617.00RTMMS11-049: GDR Security Update2494088June 14, 2011
10.50.1600.1RTMMay 10, 2010

SQL Server 2008

Build number or versionService PackUpdateKB ArticleRelease date
10.00.6535.00SP3MS15-058: QFE Security Update3045308July 14, 2015
10.00.6241.00SP3MS15-058: GDR Security Update3045311July 14, 2015
10.00.5890.00SP3MS15-058: QFE Security Update3045303July 14, 2015
10.00.5869.00SP3MS14-044: QFE Security Update2984340, 2977322August 12, 2014
10.00.5867.00(on-demand update package)2888996, 2877204, 2920987
10.00.5861.00SP3CU172958696May 19, 2014
10.00.5852.00SP3CU162936421March 17, 2014
10.00.5850.00SP3CU152923520January 20, 2014
10.00.5848.00SP3CU142893410November 18, 2013
10.00.5846.00SP3CU132880350September 16, 2013
10.00.5844.00SP3CU122863205July 15, 2013
10.00.5840.00SP3CU112834048May 20, 2013
10.00.5835.00SP3CU102814783March 18, 2013
10.00.5829.00SP3CU92799883January 21, 2013
10.00.5828.00SP3CU82771833November 19, 2012
10.00.5826.00SP3MS12-070: QFE Security Update2716435October 9, 2012
10.00.5794.00SP3CU72738350September 17, 2012
10.00.5788.00SP3CU62715953July 16, 2012
10.00.5785.00SP3CU52696626May 21, 2012
10.00.5775.00SP3CU42673383March 19, 2012
10.00.5770.00SP3CU32648098January 16, 2012
10.00.5768.00SP3CU22633143November 21, 2011
10.00.5766.00SP3CU12617146October 17, 2011
10.00.5538.00SP3MS15-058: GDR Security Update3045305July 14, 2015
10.00.5520.00SP3MS14-044: GDR Security Update2977321August 12, 2014
10.00.5512.00SP3MS12-070: GDR Security Update2716436October 9, 2012
10.00.5500.00SP3RTW / PCU 32546951October 6, 2011
10.00.4371.00SP2MS12-070: QFE Security Update2716433October 9, 2012
10.00.4333.00SP2CU112715951July 16, 2012
10.00.4332.00SP2CU102696625May 21, 2012
10.00.4330.00SP2CU92673382March 19, 2012
10.00.4326.00SP2CU82648096January 16, 2012
10.00.4323.00SP2CU72617148November 21, 2011
10.00.4321.00SP2CU62582285September 19, 2011
10.00.4316.00SP2CU52555408July 18, 2011
10.00.4311.00SP2MS11-049: QFE Security Update2494094June 14, 2011
10.00.4285.00SP2CU42527180May 16, 2011
10.00.4279.00SP2CU32498535March 17, 2011
10.00.4272.00SP2CU22467239January 17, 2011
10.00.4266.00SP2CU12289254November 15, 2010
10.00.4067.00SP2MS12-070: GDR Security Update2716434October 9, 2012
10.00.4064.00SP2MS11-049: GDR Security Update2494089June 14, 2011
10.00.4000.00SP2RTW / PCU 22285068September 29, 2010
10.00.2850.0SP1CU162582282September 19, 2011
10.00.2847.0SP1CU152555406July 18, 2011
10.00.2841.0SP1MS11-049: QFE Security Update2494100June 14, 2011
10.00.2821.00SP1CU142527187May 16, 2011
10.00.2816.00SP1CU132497673March 17, 2011
10.00.2808.00SP1CU122467236January 17, 2011
10.00.2804.00SP1CU112413738November 15, 2010
10.00.2799.00SP1CU102279604September 20, 2010
10.00.2789.00SP1CU92083921July 19, 2010
10.00.2775.00SP1CU8981702May 17, 2010
10.00.2766.00SP1CU7979065March 26, 2010
10.00.2757.00SP1CU6977443January 18, 2010
10.00.2746.00SP1CU5975977November 16, 2009
10.00.2734.00SP1CU4973602September 21, 2009
10.00.2723.00SP1CU3971491July 20, 2009
10.00.2714.00SP1CU2970315May 18, 2009
10.00.2710.00SP1CU1969099April 16, 2009
10.00.2573.00SP1MS11-049: GDR Security update2494096June 14, 2011
10.00.2531.00SP1RTW / PCU 1April, 2009
10.00.1835.00RTMCU10979064March 15, 2010
10.00.1828.00RTMCU9977444January 18, 2010
10.00.1823.00RTMCU8975976November 16, 2009
10.00.1818.00RTMCU7973601September 21, 2009
10.00.1812.00RTMCU6971490July 20, 2009
10.00.1806.00RTMCU5969531May 18, 2009
10.00.1798.00RTMCU4963036March 16, 2009
10.00.1787.00RTMCU3960484January 19, 2009
10.00.1779.00RTMCU2958186November 19, 2008
10.00.1763.00RTMCU1956717September 22, 2008
10.00.1600.22RTMAugust 6, 2008

SQL Server 2005

Build number or versionService PackUpdateKB ArticleRelease date
9.00.5324SP4MS12-070: QFE Security update2716427October 9, 2012
9.00.5292SP4MS11-049: QFE Security update2494123June 14, 2011
9.00.5266SP4CU32507769March 22, 2011
9.00.5259SP4CU22489409February 21, 2010
9.00.5254SP4CU12464079December 23, 2010
9.00.5069SP4MS12-070: GDR Security update2716429October 9, 2012
9.00.5057SP4MS11-049: GDR Security update2494120June 14, 2011
9.00.5000SP4RTW / PCU4December 16, 2010
9.00.4340SP3MS11-049: QFE Security update2494112June 14, 2011
9.00.4325SP3CU152507766March 22, 2011
9.00.4317SP3CU142489375February 21, 2011
9.00.4315SP3CU132438344December 20, 2010
9.00.4311SP3CU122345449October 18, 2010
9.00.4309SP3CU112258854August 16, 2010
9.00.4305SP3CU10983329June 21, 2010
9.00.4294SP3CU9980176April 19, 2010
9.00.4285SP3CU8978915February 16, 2010
9.00.4273SP3CU7976951December 21, 2009
9.00.4266SP3CU6974648October 19, 2009
9.00.4262SP3MS09-062: QFE Security update970894October 13, 2009
9.00.4230SP3CU5972511August 17, 2009
9.00.4226SP3CU4970279June 15, 2009
9.00.4220SP3CU3967909April 20, 2009
9.00.4211SP3CU2961930February 16, 2009
9.00.4207SP3CU1959195December 19, 2008
9.00.4060SP3MS11-049: GDR Security update2494113June 14, 2011
9.00.4053SP3MS09-062: GDR Security update970892October 13, 2009
9.00.4035SP3RTW955706December 15, 2008
9.00.3356SP2CU17976952December 21, 2009
9.00.3355SP2CU16974647October 19, 2009
9.00.3353SP2MS09-062: QFE Security update970896October 13, 2009
9.00.3330SP2CU15972510August 17, 2009
9.00.3328SP2CU14970278June 15, 2009
9.00.3325SP2CU13967908April 20, 2009
9.00.3315SP2CU12960485February 16, 2009
9.00.3310SP2MS09-004: QFE Security update960090February 10, 2009
9.00.3301SP2CU11958735December 15, 2008
9.00.3294SP2CU10956854October 21, 2008
9.00.3282SP2MS08-052: Security update954607September 9, 2008
9.00.3282SP2CU9953752August 18, 2008
9.00.3257SP2CU8951217June 16, 2008
9.00.3239SP2CU7949095April 14, 2008
9.00.3233SP2MS08-040: QFE Security update948108July 8, 2008
9.00.3228SP2CU6946608February 18, 2008
9.00.3215SP2CU5943656December 17, 2007
9.00.3200SP2CU4941450October 15, 2007
9.00.3186SP2CU3939537August 20, 2007
9.00.3175SP2CU2936305June 18, 2007
9.00.3161SP2CU1935356April 16, 2007
9.00.3152SP2Rollup933097May 15, 2007
9.00.3080SP3MS09-062: GDR Security update970895October 13, 2009
9.00.3077SP4MS09-004: GDR Security update960089February 10, 2009
9.00.3073SP5MS08-052: GDR Security update954606September 9, 2008
9.00.3068SP6MS08-040: GDR Security update948109July 8, 2008
9.00.3042SP2937137
9.00.2047SP1
9.00.1399RTM

SQL Server 2000

Build number or versionVersion description, (KB number for that update), release date
8.00.2283Post-SP4 hotfix for MS09-004 (971524)
8.00.2282MS09-004: KB959420 October 29,2008
8.00.2273MS08-040 - KB 948111 July 8, 2008
8.00.2040Post-SP4 AWE fix (899761)
8.00.2039SQL Server 2000 SP4
8.00.1007Update.exe Hotfix Installer Baseline 2 (891640)
8.00.977Update.exe Hotfix Installer Baseline 1 (884856)
8.00.818 (821277)
8.00.765 Post SP3 hotfix rollup
8.00.760 SQL Server 2000 SP3 or SP3a (8.00.766 ssnetlib.dll)
8.00.701 Hotfix Installer v.1 released
8.00.534 SQL Server 2000 SP2
8.00.384 SQL Server 2000 SP1
8.00.194 SQL Server 2000 RTM or MSDE 2.0

Older versions of SQL Server

SQL Server 7.0

Use the version number in the following table to identify the product or service pack level.

Version numberService pack
7.00.1063SQL Server 7.0 Service Pack 4
7.00.961SQL Server 7.0 Service Pack 3
7.00.842SQL Server 7.0 Service Pack 2
7.00.699SQL Server 7.0 Service Pack 1
7.00.623SQL Server 7.0 RTM

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
301511 How to obtain the latest SQL Server 7.0 service pack

SQL Server 6.5

Use the version number in the following table to identify the product or service pack level.

Version numberService pack
6.50.479SQL Server 6.5 Service Pack 5a Update
6.50.416SQL Server 6.5 Service Pack 5a
6.50.415SQL Server 6.5 Service Pack 5
6.50.281SQL Server 6.5 Service Pack 4
6.50.258SQL Server 6.5 Service Pack 3
6.50.240SQL Server 6.5 Service Pack 2
6.50.213SQL Server 6.5 Service Pack 1
6.50.201SQL Server 6.5 RTM

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
273914 Readme.txt for SQL Server 6.5 post-Service Pack 5a Update
service pack identify version edition
Eigenschaften

Artikelnummer: 321185 – Letzte Überarbeitung: 11/17/2016 17:44:00 – Revision: 101.0

Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2000 64-bit Edition, Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 6.5 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Analysis Services, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Enterprise Evaluation, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Express with Advanced Services, Microsoft SQL Server 2008 Integration Services, Microsoft SQL Server 2008 R2 Analysis Services, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Express, Microsoft SQL Server 2008 R2 Express with Advanced Services, Microsoft SQL Server 2008 R2 Reporting Services, Microsoft SQL Server 2008 R2 Standard, Microsoft SQL Server 2008 R2 Standard Edition for Small Business, Microsoft SQL Server 2008 R2 Web, Microsoft SQL Server 2008 R2 Workgroup, Microsoft SQL Server 2008 Reporting Services, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Web, Microsoft SQL Server 2008 Workgroup, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Express, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Web, Microsoft SQL Server 2012 Business Intelligence, Microsoft SQL Server 2012 Enterprise Core, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web

  • kbsqlsetup kbhowtomaster KB321185
Feedback