Martyn Simpson

SQL Server Version Numbers

Written by

Martyn Simpson

in

SQL Server version numbers typically look something like 13.0.5026.0.

The list below reflects the major version numbering as it stood at the time of writing and is intended as a quick reference rather than a complete current release matrix.

  • SQL Server 2017 — 13.x.xxxx.x
  • SQL Server 2016 — 12.x.xxxx.x
  • SQL Server 2012 — 11.x.xxxx.x
  • SQL Server 2008 R2 — 10.50.xxxx.x (final build 10.50.6000.34)
  • SQL Server 2008 — 10.0.xxxx.xx (final build 10.0.6000.29)
  • SQL Server 2005 — 9.xx.xxxx.xx (final build 9.00.5000.00)

Determine SQL Server version

To determine the version of SQL Server, you can use any of the following methods.

Method 1:
Connect to the server using Object Explorer in SQL Server Management Studio. Once connected, the version information is typically shown in parentheses, alongside the username used to connect to the instance.

Method 2:
Look at the first few lines of the ERRORLOG file for that instance. By default, the error log is located under:

Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG

and archived logs will appear as ERRORLOG.n.

The entries may look something like this:

2011-03-27 22:31:33.50 Server      Microsoft SQL Server 2008 (SP1) -
10.0.2531.0 (X64)

                March 29 2009 10:11:52

                Copyright (c) 1988-2008 Microsoft Corporation

Express Edition (64-bit)
on Windows NT 6.1 <X64> (Build 7600: )

This entry provides the key product information, including version, service pack/update level, architecture, edition, and the operating system version.

Method 3:
Connect to the instance and run:

SELECT @@VERSION

An example of the output is:

Microsoft SQL Server 2008 (SP1) -
10.0.2531.0 (X64)
  March 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation
Express Edition (64-bit)
  on Windows NT 6.1 <X64> (Build 7600: )

Method 4:
Connect to the instance and run the following in SQL Server Management Studio:

SELECT SERVERPROPERTY('productversion'),
       SERVERPROPERTY('productlevel'),
       SERVERPROPERTY('edition')

This query works for SQL Server 2000 and later.

It returns:

  • the product version (for example, 10.0.1600.22)
  • the product level (for example, RTM)
  • the edition (for example, Enterprise)

Reference

https://support.microsoft.com/en-gb/help/321185/how-to-determine-the-version-edition-and-update-level-of-sql-server-an

More posts