SQL Server Internal Versions

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';