Introduction
I always very much confused about SQL Server Versions. To check the SQL Server version by TSQL we may run below script.
Script 01
|
1 2 |
SELECT @@VERSION AS 'SQL Server Version', SERVERPROPERTY ('productlevel') as Product Level |
Result
SQL Server Version : Microsoft SQL Server 2016 (SP2) (KB4052908) – 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )
ProductLevel: SP2
Script 02
|
1 |
xp_msver |
Result
Script 03
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
-- ProducrVirsion -- ProductLevel -- Edition -- MachineName -- LicenseType -- LicensesNumber -- ExpirationDate -- SqlServerInstallationDate SELECT SERVERPROPERTY('productversion') as ProductVersion, SERVERPROPERTY ('productlevel') as ProductLevel, SERVERPROPERTY ('edition') as Edition, SERVERPROPERTY ('MachineName') as MachineName, SERVERPROPERTY ('LicenseType') as LicenseType, SERVERPROPERTY ('NumLicenses') as LicensesNum, DATEADD(dd,180,create_date) as ExpirationDate, create_date as SqlServerInstallationDate FROM sys.server_principals WHERE name='NT AUTHORITY\SYSTEM' |
Result
List of Microsoft SQL Server Release Version
| # | Version | Year | Release Name |
| 1). | 1.0 (OS/2) | 1989 | SQL Server 1.0 (16-bit) |
| 2). | 1.1 (OS/2) | 1991 | SQL Server 1.1 (16-bit) |
| 3). | 4.2A (OS/2) | 1992 | SQL Server 4.2A (16-bit) |
| 4). | 4.2B (OS/2) | 1993 | SQL Server 4.2B (16-bit) |
| 5). | 4.21a (WinNT) | 1993 | SQL Server 4.21a |
| 6). | 6 | 1995 | SQL Server 6.0 |
| 7). | 6.5 | 1996 | SQL Server 6.5 |
| 8). | 7 | 1998 | SQL Server 7.0 |
| 9). | 0 | 1999 | SQL Server 7.0 OLAP Tools |
| 10). | 8 | 2000 | SQL Server 2000 |
| 11). | 8 | 2003 | SQL Server 2000 64-bit Edition |
| 12). | 9 | 2005 | SQL Server 2005 |
| 13). | 10 | 2008 | SQL Server 2008 |
| 14). | 10.25 | 2010 | Azure SQL database (initial release) |
| 15). | 10.5 | 2010 | SQL Server 2008 R2 |
| 16). | 11 | 2012 | SQL Server 2012 |
| 17). | 12 | 2014 | SQL Server 2014 |
| 18). | 13 | 2016 | SQL Server 2016 |
| 19). | 14 | 2017 | SQL Server 2017 |
| 20). | Upcoming | 2019 | SQL Server 2019 |
