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

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 2016CU1 for 2016 SP1 (13.0.4411.0 – January 2017)

    CU4 for 2016 RTM (13.0.2193.0 – January 2017)
    SQL Server 2016 builds
    SQL Server 2014SQL Server 2014 SP2 (12.0.5000.0 – December 2016)CU3 for 2014 SP2  (12.0.5538.0 – December 2016)
    CU10 for 2014 SP1  (12.0.4491.0 –December 2016)
    SQL Server 2014 builds
    SQL Server 2012SQL Server 2012 SP3 (11.0.6020.0 – November 2015)

    CU7 for 2012 SP3 (11.0.6579.0 – January 2017)

    CU16 for 2012 SP2 (11.0.5678.0 – January 2017)

    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
How to determine the version of SQL Server Client tools
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
SQL Server replication
Full-text search
SQL Server Master Data Services (MDS)
SQL Server Native Client
SQL Server Browser
SQL Server Writer
The Microsoft .NET Framework
SQL Azure
SQL Server CE

More Information

Frequently asked questions
Frequently used terms and acronyms
SQL Server complete version list table
Older versions of SQL Server
Vlastnosti

ID článku: 321185 – Posledná kontrola: 19. 1. 2017 – Revízia: 4

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 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Business Intelligence, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web, Microsoft SQL Server 2014 Web

Pripomienky