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 1: Connect to the server by using Object Explorer in SQL Server Management Studio. To determine the version of SQL Server, you can use any of the following methods. 'Latest' = During the past 12 months Determine which version and edition of SQL Server Database Engine is running Latest updates available for currently supported versions of SQL ServerĮach of the following links provides information for all of the applicable products and technologies. To find the edition of your SQL Server instance, you can use one of the procedures in Method 2 through Method 5 in the Determine which version and edition of SQL Server Database Engine is running section.įor information about SQL Server Support lifecycle, see SQL Server support lifecycle information. 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. Original product version: SQL Server Original KB number: 321185 SummaryĪ 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.

This article lists various builds or updates that are available for different versions of SQL Server and describe the procedures to determine the version of SQL Server that is running on a given system.

Honey select update 12/22