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 Querona. 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 Querona 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 Querona 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 Querona installed on the server. 3 = Enterprise 5 = SQL Azure Base data type: int |
HadrManagerStatus |
2 = Not started and failed. |
InstanceName |
Returns: Querona 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 Querona. 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 Querona, 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 Querona. 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. |
QueronaInstanceID |
Querona instance ID which the function is run against. |
Return types#
sql_variant
Example#
SELECT SERVERPROPERTY('MachineName') AS ComputerName;