license_enabled

Description

Returns 1 if a feature’s license is enabled, 0 if the license is not enabled, or null if you specify an invalid license name.

Syntax

license_enabled("ase_server" | "ase_ha" | "ase_dtm" | "ase_java" | 
	"ase_asm")

Parameters

ase_server

specifies the license for Adaptive Server.

ase_ha

specifies the license for the Adaptive Server high availability feature.

ase_dtm

specifies the license for Adaptive Server distributed transaction management features.

ase_java

specifies the license for the Adaptive Server Java feature.

ase_asm

specifies the license for Adaptive Server advanced security mechanism.

Examples

Example 1

Indicates that the license for the Adaptive Server distributed transaction management feature is enabled:

select license_enabled("ase_dtm")

--------------
             1

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute license_enabled.

See also

System procedure sp_configure