TSQL script to get common SQL Server properties (edition, instancename et al) [more]

SELECT
  SERVERPROPERTY(‘Collation’) Collation,
  SERVERPROPERTY(‘Edition’) Edition,
  SERVERPROPERTY(‘Engine Edition’) EngineEdition,
  SERVERPROPERTY(‘InstanceName’) InstanceName,
  SERVERPROPERTY(‘IsClustered’) IsClustered,
  SERVERPROPERTY(‘IsFullTextInstalled’) IsFullTextInstalled,
  SERVERPROPERTY(‘IsIntegratedSecurityOnly’) IsIntegratedSecurityOnly,
  SERVERPROPERTY(‘IsSingleUser’) IsSingleUser,
  SERVERPROPERTY(‘IsSyncWithBackup’) IsSyncWithBackup,
  SERVERPROPERTY(‘LicenseType’) LicenseType,
  SERVERPROPERTY(‘MachineName’) MachineName,
  SERVERPROPERTY(‘NumLicenses’) NumLicenses,
  SERVERPROPERTY(‘ProcessID’) ProcessID,
  SERVERPROPERTY(‘ProductVersion’) ProductVersion,
  SERVERPROPERTY(‘ProductLevel’) ProductLevel,
  SERVERPROPERTY(‘ServerName’) ServerName

Taken from: http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/21/2994.aspx