LLI Wiki — My Digital Knowledge Base

SQL Server: version number to release name mapping

Lookup table between major version numbers (8.0 to 16.0) and SQL Server 2000 to 2022 releases.

Mapping between the internal SQL Server major version number (the one returned by SERVERPROPERTY('ProductVersion')) and the marketing version.

Major version SQL Server version
8.0 SQL Server 2000
9.0 SQL Server 2005
10.0 SQL Server 2008
10.5 SQL Server 2008 R2
11.0 SQL Server 2012
12.0 SQL Server 2014
13.0 SQL Server 2016
14.0 SQL Server 2017
15.0 SQL Server 2019
16.0 SQL Server 2022

To read the version of an instance:

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion;

End-of-support dates for each version are published by Microsoft on the product's "Microsoft Lifecycle" page.

Mastodon LLIMastodon SocialFosstodon