SERVERPROPERTY
Returns property information about the server instance.
Syntax
SERVERPROPERTY ( 'propertyname' )
Arguments
'propertyname'
Is an expression that contains the property information to be returned for the server. propertyname can be one of the following values.
| Property | Values returned |
|---|---|
| BuildClrVersion | Version of the Microsoft .NET Framework common language runtime (CLR) that was used while building the instance of Lyftron. |
| Base data type: nvarchar(128) | |
| Collation | Name of the default collation for the server. |
| Default is: 'SQL_Latin1_General_CP1_CI_AS' | |
| Base data type: nvarchar(128) | |
| CollationID | ID of the Lyftron collation. |
| Default is: 872468488 | |
| Base data type: int | |
| ComparisonStyle | Windows comparison style of the collation. |
| Default is: 196609 | |
| Base data type: int | |
| ComputerNamePhysicalNetBIOS | NetBIOS name of the local computer on which the instance of Lyftron is currently running. |
| Base data type: nvarchar(128) | |
| Edition | Returns: |
| 'Enterprise Edition' | |
| 'SQL Azure' | |
| Base data type: nvarchar(128) | |
| EditionID | 1872460670 = Enterprise Edition |
| 1674378470 = SQL Azure | |
| Base data type: bigint | |
| EngineEdition | Database Engine edition of the instance of Lyftron installed on the server. |
| 3 = Enterprise | |
| 5 = SQL Azure | |
| Base data type: int | |
| HadrManagerStatus | 2 = Not started and failed. |
| InstanceName | Returns: Lyftron |
| Base data type: nvarchar(128) | |
| IsAdvancedAnalyticsInstalled | Returns 1 if the Advanced Analytics feature was installed during setup; 0 if Advanced Analytics was not installed. |
| IsClustered | Server instance is configured in a failover cluster. |
| 1 = Clustered. | |
| 0 = Not Clustered. | |
| NULL = Input is not valid, an error, or not applicable. | |
| Base data type: int | |
| IsFullTextInstalled | The full-text and semantic indexing components are installed on the current instance of Lyftron. |
| 1 = Full-text and semantic indexing components are installed. | |
| 0 = Full-text and semantic indexing components are not installed. | |
| NULL = Input is not valid, an error, or not applicable. | |
| Base data type: int | |
| IsHadrEnabled | 0 = The Always On availability groups feature is disabled. |
| IsIntegratedSecurityOnly | Server is in integrated security mode. |
| 1 = Integrated security (Windows Authentication) | |
| 0 = Not integrated security. | |
| NULL = Input is not valid, an error, or not applicable. | |
| Base data type: int | |
| IsLocalDB | NULL = Input is not valid, an error, or not applicable. |
| IsSingleUser | Server is in single-user mode. |
| 1 = Single user. | |
| 0 = Not single user | |
| NULL = Input is not valid, an error, or not applicable. | |
| Base data type: int | |
| LCID | Windows locale identifier (LCID) of the collation. |
| Default is: 1033 | |
| Base data type: int | |
| LicenseType | Always returns DISABLED. |
| Base data type: nvarchar(128) | |
| MachineName | Windows computer name on which the server instance is running. |
| NULL = Input is not valid, an error, or not applicable. | |
| Base data type: nvarchar(128) | |
| NumLicenses | Always returns NULL. |
| Base data type: int | |
| ProcessID | Always returns 0. |
| Base data type: int | |
| ProductLevel | Always returns: SP2 |
| Base data type: nvarchar(128) | |
| ProductVersion | Version of the instance of Lyftron, in the form of 'major.minor.build.revision'. |
| Base data type: nvarchar(128) | |
| ResourceLastUpdateDateTime | Returns the date and time that the Resource database was last updated. |
| Base data type: datetime | |
| ResourceVersion | Returns the version Resource database. |
| Base data type: nvarchar(128) | |
| ServerName | Both the Windows server and instance information associated with a specified instance of Lyftron. |
| Base data type: nvarchar(128) | |
| SqlCharSet | The SQL character set ID from the collation ID. |
| Default is: 1 | |
| Base data type: tinyint | |
| SqlCharSetName | The SQL character set name from the collation. |
| Default is: 'iso_1' | |
| Base data type: nvarchar(128) | |
| SqlSortOrder | The SQL sort order ID from the collation |
| Default is: 52 | |
| Base data type: tinyint | |
| SqlSortOrderName | The SQL sort order name from the collation. |
| Default is: 'nocase_iso' | |
| Base data type: nvarchar(128) | |
| FilestreamShareName | The name of the share used by FILESTREAM. |
| Default is: 'SQL2012' | |
| FilestreamConfiguredLevel | Returns 0. |
| FilestreamEffectiveLevel | Returns 0. |
| LyftronInstanceID | Lyftron instance ID which the function is run against. |
Return types
sql_variant
Example
SELECT SERVERPROPERTY('MachineName') AS ComputerName;