SQL Server properties

SELECT
   SERVERPROPERTY('BuildClrVersion') AS [BuildClrVersion]
 , SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerNamePhysicalNetBIOS
 , SERVERPROPERTY('ServerName') AS [ServerName]
 , SERVERPROPERTY('InstanceName') AS [InstanceName]
 , SERVERPROPERTY('Collation') AS [Collation]
 , SERVERPROPERTY('ComparisonStyle') AS [ComparisonStyle]
 , SERVERPROPERTY('Edition') AS [Edition]
 , SERVERPROPERTY('EngineEdition') AS [EngineEdition]
 , SERVERPROPERTY('IsClustered') AS [IsClustered]
 , SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled]
 , SERVERPROPERTY('IsIntegratedSecurityOnly') AS [IsIntegratedSecurityOnly]
 , SERVERPROPERTY('IsSingleUser') AS [IsSingleUser]
 , SERVERPROPERTY('LCID') AS [LCID]
 , SERVERPROPERTY('LicenseType') AS [LicenseType]
 , SERVERPROPERTY('MachineName') AS [MachineName]
 , SERVERPROPERTY('NumLicenses') AS [NumLicenses]
 , SERVERPROPERTY('ProcessID') AS [ProcessID]
 , SERVERPROPERTY('ProductVersion') AS [ProductVersion]
 , SERVERPROPERTY('ProductLevel') AS [ProductLevel]
 , SERVERPROPERTY('ResourceLastUpdateDateTime') AS [ResourceLastUpdateDateTime]
 , SERVERPROPERTY('ResourceVersion') AS [ResourceVersion]
 , SERVERPROPERTY('SqlCharSetName') AS [SqlCharSetName]
 , SERVERPROPERTY('SqlSortOrder') AS [SqlSortOrder]
 , SERVERPROPERTY('SqlSortOrderName') AS [SqlSortOrderName];
 GO