SELECT
SERVERPROPERTY('MachineName') AS HostName
,SERVERPROPERTY('InstanceName') AS InstanceName
,SERVERPROPERTY('Edition') AS EditionInfo
,SERVERPROPERTY('ProductLevel') AS ProductType
,CASE SERVERPROPERTY('IsClustered')
WHEN 1 THEN 'Clustered'
ELSE 'StandAlone'
END AS SQLServerType
,@@VERSION AS SQLServerVersion