SELECT
SERVERPROPERTY('MachineName') as Host,
SERVERPROPERTY('InstanceName') as Instance,
SUBSTRING(@@VERSION, 1,25) as Version,
SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
SERVERPROPERTY('ProductVersion') AS 'Patch Level',
SERVERPROPERTY('ProductLevel') as SP, /* RTM or SP1 etc*/
Case SERVERPROPERTY('IsClustered')
when 1 then 'CLUSTERED' else
'STANDALONE' end as ServerType
SERVERPROPERTY('MachineName') as Host,
SERVERPROPERTY('InstanceName') as Instance,
SUBSTRING(@@VERSION, 1,25) as Version,
SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
SERVERPROPERTY('ProductVersion') AS 'Patch Level',
SERVERPROPERTY('ProductLevel') as SP, /* RTM or SP1 etc*/
Case SERVERPROPERTY('IsClustered')
when 1 then 'CLUSTERED' else
'STANDALONE' end as ServerType