Export (0) Print
Expand All

SERVERPROPERTY (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see SERVERPROPERTY (Transact-SQL).

Returns property information about the Microsoft Azure SQL Database server. 


SERVERPROPERTY ( propertyname )

propertyname

An expression that contains the property information to be returned for the server. propertyname can be one of the following values:

 

Property Description Value in Microsoft Azure SQL Database

BuildClrVersion

Version of the Microsoft .NET Framework common language runtime (CLR) that was used while building the instance of SQL Server.

Base data type: nvarchar(128)

NULL

Collation

NULL = Input is not valid, or an error.

Base data type: nvarchar(128)

SQL_Latin1_General_CP1_CI_AS

CollationID

ID of the SQL Server collation.

Base data type: int

872468488

ComparisonStyle

Windows comparison style of the collation.

Base data type: int

196609

ComputerNamePhysicalNetBIOS

NetBIOS name of the local computer on which the instance of SQL Server is currently running.

NULL = Input is not valid, an error, or not applicable.

Base data type: nvarchar(128)

NULL

Edition

Installed product edition of the instance of SQL Server. Use the value of this property to determine the features and the limits, such as maximum number of CPUs, that are supported by the installed product.

Base data type: nvarchar(128)

Azure SQL Database

EditionID

Is an identification number that represents the installed product edition of the instance of SQL Server. Use the value of this property to determine features and limits, such as maximum number of CPUs that are supported by the installed product.

Base data type: int

1674378470

EngineEdition

Database Engine edition of the instance of SQL Server installed on the server.

1 = Personal or Desktop Engine (Not available for SQL Server.)

2 = Standard (This is returned for Standard and Workgroup.)

3 = Enterprise (This is returned for Enterprise, Enterprise Evaluation, and Developer.)

4 = Express (This is returned for Express, Express with Advanced Services, and Windows Embedded SQL.)

5 = Azure SQL Database

Base data type: int

5

InstanceName

Name of the instance to which the user is connected.

Returns NULL if the instance name is the default instance, if the input is not valid, or error.

Base data type: nvarchar(128)

NULL

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

NULL

IsFullTextInstalled

The full-text feature is installed with the current instance of SQL Server.

1 = Full-text is installed.

0 = Full-text is not installed.

NULL = Input is not valid, an error, or not applicable.

Base data type: int

0

IsIntegratedSecurityOnly

Server is in integrated security mode.

1 = Integrated security.

0 = Not Integrated security.

NULL = Input is not valid, an error, or not applicable.

Base data type: int

0

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

0

LCID

Windows locale identifier (LCID) of the collation.

Base data type: int

1033

LicenseType

Mode of this instance of SQL Server.

PER_SEAT = Per Seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled.

Base data type: nvarchar(128)

DISABLED

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)

NULL

NumLicenses

Number of client licenses registered for this instance of SQL Server if in Per Seat mode.

Number of processors licensed for this instance of SQL Server if in per-processor mode.

Returns NULL when the server is none of these.

Base data type: int

NULL

ProcessID

Process ID of the SQL Server service. ProcessID is useful in identifying which Sqlservr.exe belongs to this instance.

NULL = Input is not valid, an error, or not applicable.

Base data type: int

NULL

ProductVersion

Version of the instance of SQL Server, in the form of 'major.minor.build'.

Base data type: nvarchar(128)

11.mm.bbbb.rr

ProductLevel

Level of the version of the instance of SQL Server.

Returns one of the following:

'RTM' = Original release version

'SPn' = Service pack version

'CTP', = Community Technology Preview version

Base data type: nvarchar(128)

RTM

ResourceLastUpdateDateTime

Returns the date and time that the Resource database was last updated.

Base data type: datetime

Last update time

ResourceVersion

Returns the version Resource database.

Base data type: nvarchar(128)

Current version

ServerName

Both the Windows server and instance information associated with a specified instance of SQL Server.

Base data type: nvarchar(128)

This returns the ServerName, the first part of the fully qualified name of your Azure SQL Database server. For example, if the fully qualified name is servername.database.windows.net the following would be returned: servername

SqlCharSet

The SQL character set ID from the collation ID.

Base data type: tinyint

1

SqlCharSetName

The SQL character set name from the collation.

Base data type: nvarchar(128)

iso_1

SqlSortOrder

The SQL sort order ID from the collation

Base data type: tinyint

52

SqlSortOrderName

The SQL sort order name from the collation.

Base data type: nvarchar(128)

nocase_iso

FilestreamShareName

The name of the share used by FILESTREAM.

NULL

FilestreamConfiguredLevel

The configured level of FILESTREAM access.

0

FilestreamEffectiveLevel

The effective level of FILESTREAM access. This value can be different than the FilestreamConfiguredLevel if the level has changed and either an instance restart or a computer restart is pending.

0

sql_variant

For more information about the SERVERPROPERTY function, see SERVERPROPERTY (Transact-SQL) in SQL Server Books Online.

Community Additions

ADD
Show:
© 2014 Microsoft