SELECT '    Server Name', @@SERVERNAME
SELECT '         DBName', db_Name()
SELECT '       HostName', host_name()
GO
SELECT  [Server Property] = 'MachineName', [Value] = SERVERPROPERTY('MachineName')
UNION SELECT 'InstanceName', SERVERPROPERTY( 'InstanceName' )
UNION SELECT 'ProductVersion', SERVERPROPERTY( 'ProductVersion' )
UNION SELECT 'ProductLevel', SERVERPROPERTY( 'ProductLevel' )
UNION SELECT 'Edition', SERVERPROPERTY( 'Edition' )
UNION SELECT 'EngineEdition', CASE SERVERPROPERTY( 'EngineEdition')
		WHEN 1 THEN 'Personal or Desktop'
		WHEN 2 THEN 'Standard'
		WHEN 3 THEN 'Enterprise'
		else '[' + convert(varchar(30), SERVERPROPERTY( 'EngineEdition')) + ']'
		 END
UNION SELECT 'LicenseType', SERVERPROPERTY( 'LicenseType' )
UNION SELECT 'NumLicenses', SERVERPROPERTY( 'NumLicenses' )
UNION SELECT 'Collation', SERVERPROPERTY( 'Collation' )
UNION SELECT 'IsClustered', SERVERPROPERTY( 'IsClustered' )
UNION SELECT 'IsFullTextInstalled', SERVERPROPERTY( 'IsFullTextInstalled' )
UNION SELECT 'IsIntegratedSecurityOnly', SERVERPROPERTY( 'IsIntegratedSecurityOnly' )
UNION SELECT 'IsSingleUser', SERVERPROPERTY( 'IsSingleUser' )
UNION SELECT 'IsSyncWithBackup', SERVERPROPERTY( 'IsSyncWithBackup' )
UNION SELECT 'ProcessID', SERVERPROPERTY( 'ProcessID' )
UNION SELECT 'ServerName', SERVERPROPERTY( 'ServerName' )
GO