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.
license_enabled("ase_server" | "ase_ha" | "ase_dtm" | "ase_java" | "ase_asm")
specifies the license for Adaptive Server.
specifies the license for the Adaptive Server high availability feature.
specifies the license for Adaptive Server distributed transaction management features.
specifies the license for the Java in Adaptive Server feature.
specifies the license for Adaptive Server advanced security mechanism.
Indicates that the license for the Adaptive Server distributed transaction management feature is enabled:
select license_enabled("ase_dtm")
-------------- 1
For information about installing license keys for Adaptive Server features, see your installation guide.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute license_enabled.
Documents Installation guide for your platform
System procedure sp_configure