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

Applies to: Microsoft SQL Server 2000 Standard EditionMicrosoft SQL Server 2000 64-bit EditionMicrosoft SQL Server 2005 Standard Edition More

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 which specific edition of SQL Server you are using.

Notes
 
  • A downloadable version of an Excel workbook that contains all the build versions together with their current support lifecycle 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 lifecycle 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 lifecycle, check the Microsoft SQL Server support lifecycle page.


    Table 1: Latest updates available for each SQL Server version
     
    Version Most recent service pack Latest cumulative update Complete version information
    SQL Server 2017 None CU12 for 2017 (14.0.3045.24 – October 2018) SQL Server 2017 builds
    SQL Server 2016 SQL Server 2016 SP2 (13.0.5026.0 – April 2018)

    CU4 for 2016 SP2 (13.0.5233.0 – November 2018)

    CU12 for 2016 SP1 (13.0.4541.0 – November 2018)

    CU9 for 2016 RTM (13.0.2216.0 – November 2017)
    SQL Server 2016 builds
    SQL Server 2014 SQL Server 2014 SP3 (12.0.6024.0 – October 2018) CU14 for 2014 SP2  (12.0.5600.1 – October 2018)
    CU13 for 2014 SP1  (12.0.4522.0 – August 2017)
    SQL Server 2014 builds
    SQL Server 2012 SQL Server 2012 SP4 (11.0.7001.0 – September 2017)
     
    CU10 for 2012 SP3 (11.0.6607.3 – August 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 R2 SQL Server 2008 R2 SP3 (10.50.6000.34 – September 2014)

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

    Note Latest and final release for this version
    None SQL Server 2008 builds
    SQL Server 2005 SQL Server 2005 SP4 (9.00.5000.00 – December 2010) None SQL Server 2005 builds

    Note "Latest" = During the past 12 months


    Table 2: Where to find more information about each version
     
    Version Service Pack information Cumulative update information
    SQL Server 2017 None 4047329 Latest cumulative update for SQL Server 2017
    SQL Server 2016 3177534 How to obtain the latest service pack for SQL Server 2016 3177312 Latest cumulative update for SQL Server 2016
    SQL Server 2014 2958069 How to obtain the latest service pack for SQL Server 2014 2936603 SQL Server 2014 build versions
    SQL Server 2012 2755533 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 R2 2527041 How to obtain the latest service pack for SQL Server 2008 R2 981356 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 2008 968382 How to obtain the latest service pack for SQL Server 2008 956909 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 2005 913089 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

More Information