Summary: Quickly identify your SQL Server build using @@VERSION and reference the comprehensive list of SQL Server 2019 release versions from CTP to RTM and GDR.
Determining Your SQL Server 2019 Build and Version
Ever wonder about the specific build and version of your SQL Server instance? Knowing your exact build number is essential for applying the correct security patches and cumulative updates. You can easily find this out using a simple T-SQL global variable:
-- Identify Server Name and Full Version Info
SELECT
@@SERVERNAME AS [Server Name],
@@VERSION AS [SQL Server and OS Version Info];
SQL Server 2019 Build History
Below is a detailed look at the various builds of SQL Server 2019 (Internal Version 15.0). This list includes the early Community Technology Previews (CTP), Release Candidates (RC), and General Distribution Releases (GDR).
| Build Number | Description / Milestone | Release Date |
|---|---|---|
| 15.0.1000.34 | CTP 2.0 | 9/24/2018 |
| 15.0.1100.94 | CTP 2.1 | 11/7/2018 |
| 15.0.1200.24 | CTP 2.2 | 12/6/2018 |
| 15.0.1300.359 | CTP 2.3 | 3/1/2019 |
| 15.0.1400.75 | CTP 2.4 | 3/26/2019 |
| 15.0.1500.28 | CTP 2.5 | 4/23/2019 |
| 15.0.1600.8 | CTP 3.0 | 5/22/2019 |
| 15.0.1700.37 | CTP 3.1 | 6/26/2019 |
| 15.0.1800.32 | CTP 3.2 | 7/24/2019 |
| 15.0.1900.25 | RC1 / Refresh | 8/29/2019 |
| 15.0.2000.5 | RTM (General Availability) | 11/4/2019 |
| 15.0.2070.41 | GDR1 | 11/4/2019 |
Official Microsoft Resources
- Servicing Update for SQL Server 2019 RTM
- Determine Version and Update Level of SQL Components
- KB4518398 - Full SQL Server 2019 Build List
Is your SQL Server out of date? Regularly checking your build number against official KB articles ensures you are protected against known vulnerabilities and performance bugs!
