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