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;

See Also