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

Applies to: Microsoft SQL Server 2005 Standard EditionMicrosoft SQL Server 2005 Express EditionMicrosoft SQL Server 2005 Developer Edition

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:

    For more information about this script, see Determining the version and edition of SQL Server and its components in TechNet Gallery.
    • Major version, servicing level, and edition of SQL Server
    • Latest updates available for your version
    • Servicing support lifecycle stage
  • 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 tables.
  • 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 2019 None   SQL Server 2019 builds
      SQL Server 2017 None CU17 for 2017 (14.0.3238.1 – October 2019) SQL Server 2017 builds
      SQL Server 2016 SQL Server 2016 SP2 (13.0.5026.0 – April 2018)

      CU10 for 2016 SP2 (13.0.5492.2 – October 2019)

      CU15 + GDR for 2016 SP1 (13.0.4604.0 – July 2019) 

      CU15 for 2016 SP1 (13.0.4574.0 – May 2019)

      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)

      CU4 for 2014 SP3 (12.0.6329.1– July 2019)

      CU18 for 2014 SP2 (12.0.5687.1– July 2019)

      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