Microsoft SQL Server Version Numbers
Find out the installed MSSQL Server version and compare it with the current release/service pack levels.
Updated 1 November 20261 min read
Contents
The currently installed version of an MSSQL Server can be found out with a simple SQL statement and compared with the service pack levels listed below:
Select @@versionSQL Server 2017 and later
Here is an overview of the most important version numbers (as of November 2026):
| SQL | RTM | Cumulative Update | Support | Ext. Support |
|---|---|---|---|---|
| 2025 | 17.0.1000.7 | 17.0.5035.5 (CU10) | 2031-01-06 | 2036-01-06 |
| 2022 | 16.0.1000.6 | 16.0.4295.3 (CU27) | 2028-01-11 | 2033-01-11 |
| 2019 | 15.0.2000.5 | 15.0.4430.1 (CU32) | 2030-01-08 | |
| 2017 | 14.0.1000.169 | 14.0.3456.2 (CU31) | 2027-10-12 |
SQL Server up to 2016
Warning: SQL Server 2016 and older are already EOL (end-of-life) and no longer receive updates!
Before SQL Server 2017, there were “service pack” releases:
| SQL | RTM | SP1 | SP2 | SP3 | SP4 |
|---|---|---|---|---|---|
| 2016 | 13.0.1601.5 | 13.0.4001.0 | 13.0.5026.0 | 13.0.6300.2 | - |
| 2014 | 12.0.2000.8 | 12.0.4100.1 | 12.0.5000.0 | 12.0.6024.0 | - |
| 2012 | 11.0.2100.60 | 11.0.3000.0 | 11.0.5058.0 | 11.0.6020.0 | 11.0.7001.0 |
| 2008R2 | 10.50.1600.1 | 10.50.2500.0 | 10.50.4000.0 | 10.50.6000.34 | - |
| 2008 | 10.0.1600.22 | 10.0.2531.0 | 10.0.4000.0 | 10.0.5500.0 | 10.0.6000.29 |
| 2005 | 9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
| 2000 | 8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| 7.0 | 7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
Source
- SQL Server Builds @ BlogSpot: Microsoft SQL Server Version List