select  @@version 

SELECT SERVERPROPERTY('ServerName') AS ServerName

, SERVERPROPERTY('MachineName') AS MachineName

, @@SERVICENAME AS InstanceName

, SERVERPROPERTY('Edition') AS Edition

, SERVERPROPERTY('ProductLevel') AS ProductLevel

, SERVERPROPERTY('ProductVersion') AS ProductVersion

, SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerName

, SERVERPROPERTY('IsClustered') AS ClusterSetting?