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 Adaptive Server Java 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.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute license_enabled.
System procedure sp_configure
