Skip to content
Blog

SQL Server Versions: Full List and How to Check Your Version

SQL Server Versions: Full List and How to Check Your Version
In this article
  1. SQL Server versions and build numbers
  2. How to find your SQL Server version
  3. 1. SELECT @@VERSION
  4. 2. SERVERPROPERTY, for scripts
  5. 3. sqlcmd from the command line
  6. 4. SSMS Object Explorer
  7. 5. The error log, when the service will not start
  8. Reading the build number
  9. Editions: what the edition in the output means
  10. What to do with the answer

The quickest way to find your SQL Server version is to connect and run SELECT @@VERSION;. The result starts with the product name and a build number such as 17.0.5005.3, and the first number tells you the release: 17 is SQL Server 2025, 16 is 2022, 15 is 2019, 14 is 2017 and 13 is 2016. SQL Server 2025 is the newest release, and 2016 and older are now past the end of Microsoft’s extended support. The tables below map every build number to its release, show how long each one is supported, and explain five ways to check what you are running.

Terminal showing sqlcmd SELECT @@VERSION returning Microsoft SQL Server 2025 RTM-CU9 17.0.5005.3, and a SERVERPROPERTY query returning version, level RTM, update level CU9 and the edition
SQL Server 2025 on Linux reporting its version: build 17.0.5005.3, RTM-CU9, from @@VERSION and SERVERPROPERTY

SQL Server’s container image is built for x86-64 only, so we ran it on an x86-64 test server. The example output below comes from the SQL Server 2025 container image, which reported cumulative update 9.

SQL Server versions and build numbers

Build numbers follow the pattern major.minor.build.revision. From Microsoft’s version history and lifecycle pages. The last column is the newest update in Microsoft’s list when we checked it:

ReleaseVersion numberFirst (RTM) buildMainstream support endsExtended support endsLatest update
SQL Server 202517.017.0.1000.7January 2031January 2036CU11, 17.0.5065.9
SQL Server 202216.016.0.1000.6January 2028January 2033CU28, 16.0.4325.4
SQL Server 201915.015.0.2000.5EndedJanuary 2030CU32 + GDR, 15.0.4510.2
SQL Server 201714.014.0.1000.169EndedOctober 2027CU31 + GDR, 14.0.3570.2
SQL Server 201613.013.0.1601.5EndedEnded (July 2026)SP3 Azure Connect feature pack + GDR, 13.0.7095.1
SQL Server 201412.012.0.2000.8EndedEnded (July 2024)SP3 CU4 + GDR, 12.0.6449.1
SQL Server 201211.011.0.2100.60EndedEndedSP4 GDR, 11.0.7512.11
SQL Server 2008 R210.5010.50.1600.1EndedEndedSP3 GDR, 10.50.6785.2
SQL Server 200810.010.00.1600.22EndedEndedSP4 GDR, 10.0.6814.4

During mainstream support, Microsoft ships regular cumulative updates with fixes and improvements. During extended support, only security updates arrive. You can see this in the version history: SQL Server 2019’s last cumulative update is CU32, and after that it has only had security fixes on top of CU32. Microsoft sells Extended Security Updates for some releases past their end date, but on a server you run yourself, plan the upgrade instead.

How to find your SQL Server version

Microsoft’s find my SQL Server version article lists five methods. Pick the one that fits what you can reach.

1. SELECT @@VERSION

Run this in SQL Server Management Studio or any other SQL client:

SELECT @@VERSION;

Output from our SQL Server 2025 container, without the empty column heading that sqlcmd prints first:

Microsoft SQL Server 2025 (RTM-CU9) (KB5122048) - 17.0.5005.3 (X64)
  Aug 27 2026 09:30:16
  Copyright (C) 2025 Microsoft Corporation
  Enterprise Developer Edition (64-bit) on Linux (Ubuntu 24.04.4 LTS) <X64>

Read it left to right: SQL Server 2025, cumulative update 9 on the original release, build 17.0.5005.3, Enterprise Developer edition, running on Linux (the container is based on Ubuntu 24.04). On Windows the last part names the Windows version instead. Microsoft’s list already had CU11 (17.0.5065.9) when we checked, so the container image was two cumulative updates behind; compare your own build with the table above.

2. SERVERPROPERTY, for scripts

When a script or monitoring tool needs one value at a time, query the properties separately instead of parsing @@VERSION:

SELECT
  SERVERPROPERTY('ProductVersion')     AS version,
  SERVERPROPERTY('ProductLevel')       AS level,
  SERVERPROPERTY('ProductUpdateLevel') AS update_level,
  SERVERPROPERTY('Edition')            AS edition;

For the instance above, this returned 17.0.5005.3, RTM, CU9 and Enterprise Developer Edition (64-bit). According to the SERVERPROPERTY reference, ProductUpdateLevel returns the cumulative update, such as CU9, or NULL if none is installed.

3. sqlcmd from the command line

On a server with no graphical tools, sqlcmd runs a single query and exits with -Q:

sqlcmd -S localhost -E -Q "SELECT @@VERSION"
sqlcmd -S localhost -U sa -Q "SELECT @@VERSION"

-E signs in with your Windows account; -U uses a SQL login and prompts for the password. Add \INSTANCENAME after the server name for a named instance.

4. SSMS Object Explorer

Connect in SQL Server Management Studio and look at the top node in Object Explorer: the version number appears in brackets after the server name. If you do not have SSMS yet, see How to install SSMS and connect to SQL Server.

5. The error log, when the service will not start

You do not need a working connection for this one. The first lines of the ERRORLOG file record the same string as @@VERSION each time the service starts. Microsoft gives the default location as Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG. That makes it the method to use when the service fails; SQL Server service is not starting covers the usual causes. Setup’s Installed SQL Server features discovery report, on the Tools page of the SQL Server Installation Center, lists every instance on the machine too.

Reading the build number

From SQL Server 2017 onwards, Microsoft no longer releases service packs, only cumulative updates (CUs) and security updates (GDRs). Each release then has two update tracks, which you can tell apart by the third part of the build number. Taking SQL Server 2025 as an example, from Microsoft’s version list:

  • 17.0.1000.7 is the original release (RTM).
  • 17.0.1xxx builds, such as 17.0.1155.3, are the GDR track: the original release plus security fixes only.
  • 17.0.4xxx and higher, such as 17.0.4085.5 (CU8 plus a security update), 17.0.5005.3 (CU9) or 17.0.5065.9 (CU11), are the CU track, with all fixes and improvements.

According to Microsoft’s servicing model article, once you install a CU the instance moves to the CU track and keeps receiving CUs and CU-based security updates for that release. To see exactly which update a build contains, search for the number in the version history page.

Editions: what the edition in the output means

EditionForKey limits (SQL Server 2025)
EnterpriseLarge and mission-critical production systemsOperating system maximum for CPU and memory
StandardMost business production workloadsLesser of 4 sockets or 32 cores; 256 GB buffer pool memory
ExpressFree; learning, small applicationsLesser of 1 socket or 4 cores; 1,410 MB buffer pool; 50 GB per database
Enterprise Developer and Standard DeveloperDevelopment and testing only, not productionSame features as Enterprise or Standard
EvaluationTrying Enterprise featuresExpires after 180 days

Some limits changed in SQL Server 2025, according to Microsoft’s editions page: in SQL Server 2022, Standard stopped at 24 cores and 128 GB of buffer pool memory, and Express databases at 10 GB. The Web edition is not available from SQL Server 2025 onwards, and the Developer edition is now split into Enterprise Developer and Standard Developer.

What to do with the answer

  • SQL Server 2016 or older: it no longer gets security updates without paid Extended Security Updates. Plan an upgrade, and test your application on the new version first.
  • SQL Server 2017 or 2019: security fixes only. Fine for now, but put the upgrade on the roadmap.
  • SQL Server 2022 or 2025: compare your build with the latest CU in Microsoft’s list and patch during a maintenance window, after a full backup.
  • Developer or Evaluation edition in production: check your licensing. Developer editions are licensed for development and test only, and Evaluation stops after 180 days.

Running SQL Server on a Windows VPS or a dedicated server? If you would like help with an upgrade or a cumulative update, our engineers are available by the hour.

Related articles

Start Building Today

Ready to Get Started?

VPS, dedicated servers, streaming and managed hosting with 24/7 support from the Ucartz team.