SQL Server Internal Versions

SQL Server Internal Versions

SQL Server Versions

RTMSP1SP2SP3SP4 
SQL Server 201613.0.1601.5
SQL Server 2014 codename SQL1412.0.2000.812.0.4100.1 or 12.1.4100.112.0.5000.0 or 12.2.5000.0
SQL Server 2012 codename Denali11.0.2100.6011.0.3000.0 or 11.1.3000.011.0.5058.0 or 11.2.5058.011.0.6020.0 or 11.3.6020.0
SQL Server 2008 R2 codename Kilimanjaro10.50.1600.110.50.2500.0 or 10.51.2500.010.50.4000.0 or 10.52.4000.010.50.6000.34 or 10.53.6000.34
SQL Server 2008 codename Katmai10.0.1600.2210.0.2531.0 or 10.1.2531.010.0.4000.0 or 10.2.4000.010.0.5500.0 or 10.3.5500.010.0.6000.29 or 10.4.6000.29
SQL Server 2005 codename Yukon9.0.1399.069.0.20479.0.30429.0.40359.0.5000
SQL Server 2000 codename Shiloh8.0.1948.0.3848.0.5328.0.7608.0.2039
SQL Server 7.0 codename Sphinx7.0.6237.0.6997.0.8427.0.9617.0.1063

Database Internal Versions and Compatibility Levels

SQL Server VersionInternal Database VersionCompatibility Level
SQL Server 2016852130
SQL Server 2014782120
SQL Server 2012706110
SQL Server 2012 CTP1684110
SQL Server 2008 R2660 / 661100
SQL Server 2008655100
SQL Server 2005 SP2+61290
SQL Server 200561190
SQL Server 200053980
SQL Server 7.051570

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

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *