SQL Server versions: builds, updates and end of support.
Which build is current, how far behind is your server, and how long will security updates still be available? We check this overview against Microsoft regularly and add what we observe in projects.
Which build is this?
In three steps, see which update is installed, how many have been released since, and how long Microsoft will continue to support the version.
- The evaluation runs entirely in your browser.
- Nothing is sent or stored.
01Run the commandin SSMS, Azure Data Studio or sqlcmd
SELECT @@VERSION;02Paste the outputor just the build number
03ResultFor the data as of date, see above
The result appears here once you have pasted something.
Current status by version
Latest build according to Microsoft and the support dates. Click a version to see its complete update list.
| Version | Latest build | Supported until | Status today |
|---|---|---|---|
| SQL Server 2025Version 17.0 · compatibility level 170 | CU917.0.5005.3 · 15 Sep 2026 | Mainstream6 Jan 2031Extended6 Jan 2036 | Mainstream support |
| SQL Server 2022Version 16.0 · compatibility level 160 | CU2716.0.4295.3 · 15 Sep 2026 | Mainstream11 Jan 2028Extended11 Jan 2033 | Mainstream support |
| SQL Server 2019Version 15.0 · compatibility level 150 | CU32 + GDR15.0.4490.9 · 8 Sep 2026 | Mainstream28 Feb 2025Extended8 Jan 2030 | Extended support |
| SQL Server 2017Version 14.0 · compatibility level 140 | CU31 + GDR14.0.3550.4 · 8 Sep 2026 | Mainstream11 Oct 2022Extended12 Oct 2027 | Extended support |
| SQL Server 2016Version 13.0 · compatibility level 130 | Azure Connect Pack + GDR13.0.7095.1 · 14 Jul 2026 | Mainstream13 Jul 2021Extended14 Jul 2026 | No support |
| SQL Server 2014Version 12.0 · compatibility level 120 | CU4 + GDR12.0.6449.1 · 10 Oct 2023 | Mainstream9 Jul 2019Extended9 Jul 2024 | No support |
| SQL Server 2012Version 11.0 · compatibility level 110 | GDR for SP411.0.7512.11 · 14 Feb 2023 | Mainstream11 Jul 2017Extended12 Jul 2022 | No support |
| SQL Server 2008 R2Version 10.50 · compatibility level 100 | GDR Security Update10.50.6785.2 · 14 Feb 2023 | Mainstream8 Jul 2014Extended9 Jul 2019 | No support |
| SQL Server 2008Version 10.0 · compatibility level 100 | GDR for SP410.0.6814.4 · 14 Feb 2023 | Mainstream8 Jul 2014Extended9 Jul 2019 | No support |
| SQL Server 2005Version 9.00 · compatibility level 90 | MS12-070: QFE Security Update9.00.5324 · 9 Oct 2012 | Mainstream12 Apr 2011Extended12 Apr 2016 | No support |
How long will updates continue?
During mainstream support, Microsoft delivers cumulative updates with bug fixes. During extended support, only security updates are provided. After that there is nothing, except through paid Extended Security Updates, where Microsoft offers them.
Mainstream support Extended support Extended Security Updates (paid) today
What we say about this in projects
- There have been no service packs since SQL Server 2017.
Microsoft delivers cumulative updates (CUs) with bug fixes, alongside security-only updates (GDR). If you stay on the GDR branch, you get security fixes but none of the bug fixes from the CUs. - Current does not mean on the day of release.
A fixed cadence with a test environment is better than chance. What matters is that the backlog does not grow over the years. Otherwise every later update becomes a project. - A version change does not have to make things faster.
Whether an upgrade helps with a performance problem depends on the workload. Some queries benefit from new optimizer features; others get different plans, which can also be worse, for example because of a new compatibility level. We check this beforehand rather than hoping. How we find root causes · One query, many plans. - End of support does not come as a surprise.
The dates are set years in advance. An upgrade with testing, high availability and a rollback path needs lead time; we plan it with you.
Change log and sources
This page is part of our reference collection. Unlike an article, it is maintained: every substantive change is listed here with its date.
- Page rebuilt: all builds from SQL Server 2005 to 2025 checked against Microsoft Learn (page date 15 Sep 2026), build checker and a page per version added.
Sources
- Latest updates and version history for SQL Server (overview, complete version tables) Page date 15 Sep 2026
- SQL Server 2025 build versions Page date 15 Sep 2026
- SQL Server 2022 build versions Page date 15 Sep 2026
- SQL Server 2019 build versions Page date 8 Sep 2026
- SQL Server 2017 build versions Page date 8 Sep 2026
- SQL Server 2016 build versions Page date 11 Nov 2025
- SQL Server 2014 build versions Page date 26 Jul 2024
- Lifecycle SQL Server 2025 Page date 18 Nov 2025
- Lifecycle SQL Server 2022 Page date 17 Nov 2022
- Lifecycle SQL Server 2019 Page date 10 Oct 2022
- Lifecycle SQL Server 2017 Page date 10 Oct 2022
- Lifecycle SQL Server 2016 Page date 27 Sep 2024
- Lifecycle SQL Server 2014 Page date 17 Sep 2024
- Lifecycle Microsoft SQL Server 2012 Page date 1 Nov 2022
- Lifecycle Microsoft SQL Server 2008 R2 Page date 1 Nov 2022
- Lifecycle Microsoft SQL Server 2008 Page date 1 Nov 2022
- Lifecycle Microsoft SQL Server 2005 Page date 25 Oct 2022
No guarantee for the information provided. The linked pages from Microsoft are authoritative. Microsoft and SQL Server are trademarks of the Microsoft group of companies.