SQL Server Internal Versions
SQL Server Versions
Database Internal Versions and Compatibility Levels
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';