TSQL to get SQL Server properties

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