SQL Server Internal Versions
SQL Server Versions
RTM | SP1 | SP2 | SP3 | SP4 | |
---|---|---|---|---|---|
SQL Server 2016 | 13.0.1601.5 | ||||
SQL Server 2014 codename SQL14 | 12.0.2000.8 | 12.0.4100.1 or 12.1.4100.1 | 12.0.5000.0 or 12.2.5000.0 | ||
SQL Server 2012 codename Denali | 11.0.2100.60 | 11.0.3000.0 or 11.1.3000.0 | 11.0.5058.0 or 11.2.5058.0 | 11.0.6020.0 or 11.3.6020.0 | |
SQL Server 2008 R2 codename Kilimanjaro | 10.50.1600.1 | 10.50.2500.0 or 10.51.2500.0 | 10.50.4000.0 or 10.52.4000.0 | 10.50.6000.34 or 10.53.6000.34 | |
SQL Server 2008 codename Katmai | 10.0.1600.22 | 10.0.2531.0 or 10.1.2531.0 | 10.0.4000.0 or 10.2.4000.0 | 10.0.5500.0 or 10.3.5500.0 | 10.0.6000.29 or 10.4.6000.29 |
SQL Server 2005 codename Yukon | 9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
SQL Server 2000 codename Shiloh | 8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
SQL Server 7.0 codename Sphinx | 7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
Database Internal Versions and Compatibility Levels
SQL Server Version | Internal Database Version | Compatibility Level |
---|---|---|
SQL Server 2016 | 852 | 130 |
SQL Server 2014 | 782 | 120 |
SQL Server 2012 | 706 | 110 |
SQL Server 2012 CTP1 | 684 | 110 |
SQL Server 2008 R2 | 660 / 661 | 100 |
SQL Server 2008 | 655 | 100 |
SQL Server 2005 SP2+ | 612 | 90 |
SQL Server 2005 | 611 | 90 |
SQL Server 2000 | 539 | 80 |
SQL Server 7.0 | 515 | 70 |
Useful Query
SELECT SERVERPROPERTY('ServerName') 'ServerName' , @@VERSION '@@version' , SERVERPROPERTY('ComputerNamePhysicalNetBIOS') 'ComputerNamePhysicalNetBIOS' , SERVERPROPERTY('MachineName') 'MachineName' , SERVERPROPERTY('InstanceName') 'InstanceName' , SERVERPROPERTY('IsClustered') 'IsClustered' , SERVERPROPERTY('BuildClrVersion') 'BuildClrVersion' , SERVERPROPERTY('Collation') 'Collation' , SERVERPROPERTY('CollationID') 'CollationID' , SERVERPROPERTY('ComparisonStyle') 'ComparisonStyle' , SERVERPROPERTY('ComputerNamePhysicalNetBIOS') 'ComputerNamePhysicalNetBIOS' , SERVERPROPERTY('Edition') 'Edition' , SERVERPROPERTY('EditionID') 'EditionID' , SERVERPROPERTY('EngineEdition') 'EngineEdition' , SERVERPROPERTY('IsFullTextInstalled') 'IsFullTextInstalled' , SERVERPROPERTY('IsIntegratedSecurityOnly') 'IsIntegratedSecurityOnly' , SERVERPROPERTY('IsSingleUser') 'IsSingleUser' , SERVERPROPERTY('LCID') 'LCID' , SERVERPROPERTY('LicenseType') 'LicenseType' , SERVERPROPERTY('NumLicenses') 'NumLicenses' , SERVERPROPERTY('ProcessID') 'ProcessID' , SERVERPROPERTY('ProductVersion') 'ProductVersion' , SERVERPROPERTY('ProductLevel') 'ProductLevel' , SERVERPROPERTY('ResourceLastUpdateDateTime') 'ResourceLastUpdateDateTime' , SERVERPROPERTY('ResourceVersion') 'ResourceVersion' , SERVERPROPERTY('ServerName') 'ServerName' , SERVERPROPERTY('SqlCharSet') 'SqlCharSet' , SERVERPROPERTY('SqlCharSetName') 'SqlCharSetName' , SERVERPROPERTY('SqlSortOrder') 'SqlSortOrder' , SERVERPROPERTY('SqlSortOrderName') 'SqlSortOrderName' , SERVERPROPERTY('FilestreamShareName') 'FilestreamShareName' , SERVERPROPERTY('FilestreamConfiguredLevel') 'FilestreamConfiguredLevel' , SERVERPROPERTY('FilestreamEffectiveLevel') 'FilestreamEffectiveLevel';