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

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.