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.