SERVERPROPERTY

Display information about the server instance.

Syntax:
      SERVERPROPERTY ( propertyname )

For boolean values ServerProperty will return 1 for True or 0 for false.

Examples

SELECT CONVERT(char(20), SERVERPROPERTY('BuildClrVersion'));
SELECT CONVERT(char(20), SERVERPROPERTY('Collation'));
SELECT CONVERT(char(20), SERVERPROPERTY('CollationID'));
SELECT CONVERT(char(20), SERVERPROPERTY('ComparisonStyle'));
SELECT CONVERT(char(20), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'));
SELECT CONVERT(char(20), SERVERPROPERTY('Edition'));
SELECT CONVERT(char(20), SERVERPROPERTY('EditionID'));
SELECT CONVERT(char(20), SERVERPROPERTY('EngineEdition'));
SELECT CONVERT(char(20), SERVERPROPERTY('InstanceName'));
SELECT CONVERT(char(20), SERVERPROPERTY('IsClustered'));
SELECT CONVERT(char(20), SERVERPROPERTY('IsFullTextInstalled'));
SELECT CONVERT(char(20), SERVERPROPERTY('IsIntegratedSecurityOnly'));
SELECT CONVERT(char(20), SERVERPROPERTY('IsSingleUser'));
SELECT CONVERT(char(20), SERVERPROPERTY('LCID'));
SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'));
SELECT CONVERT(char(20), SERVERPROPERTY('MachineName'));
SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'));
SELECT CONVERT(char(20), SERVERPROPERTY('ProcessID'));
SELECT CONVERT(char(20), SERVERPROPERTY('ProductVersion'));
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'));
SELECT CONVERT(char(20), SERVERPROPERTY('ResourceLastUpdateDateTime'));
SELECT CONVERT(char(20), SERVERPROPERTY('ResourceVersion'));
SELECT CONVERT(char(20), SERVERPROPERTY('ServerName'));
SELECT CONVERT(char(20), SERVERPROPERTY('SqlCharSet'));
SELECT CONVERT(char(20), SERVERPROPERTY('SqlCharSetName'));
SELECT CONVERT(char(20), SERVERPROPERTY('SqlSortOrder'));
SELECT CONVERT(char(20), SERVERPROPERTY('SqlSortOrderName'));

"Riches do not consist in the possession of treasures, but in the use made of them" ~ Napoleon Bonaparte

Related commands:

@@SERVERNAME