Using xp_sqllitespeed_licenseinfo you can register a new LiteSpeed license key or remove licensing information (unlicense LiteSpeed). Without the arguments, this extended stored procedure returns a result set showing the currently installed LiteSpeed license.
EXEC master.dbo.xp_sqllitespeed_licenseinfo
[ @licensekey = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX-111-22222-YY'
[, @ShowLicenseNumber = 1 ]
[, @store = 1]
| @remove = 1]
|
@licensekey |
Passes license key value. |
| @ShowLicenseNumber = 1 | Show the Customer License Number. The Customer License Number is part of the license key and is required to access support. |
|
@store = 1 |
Overwrites any currently stored licenses with the valid license supplied. |
| @remove = 1 |
Removes the currently stored license. |
View information about the supplied license key:
EXEC master.dbo.xp_sqllitespeed_licenseinfo
@licensekey = 'Your-valid-license-key'
Register a license key:
EXEC master.dbo.xp_sqllitespeed_licenseinfo
@licensekey = 'Your-valid-license-key'
, @store=1
Remove license key:
EXEC master.dbo.xp_sqllitespeed_licenseinfo
@remove= 1
Show the Customer License Number. The Customer License Number is part of the license key and is required to access support.
EXEC master.dbo.xp_sqllitespeed_licenseinfo @ShowLicenseNumber = 1
| Column Name | Data Type | Description |
|---|---|---|
| Product Name | nvarchar(128) | LiteSpeed for SQL Server. |
| License Key | nvarchar(128) | Key license value. |
| License Type | nvarchar(128) |
One of the following:
|
| Edition | nvarchar(128) |
Enterprise or Standard. |
| Site License | bit |
Whether the key is a Site license key that is used company-wide. |
| Gigabyte Limit | int | Database size limit in GB. If there is a gigabyte limit set in the license (any value larger than 0), LiteSpeed will fail any backup of databases larger than the limit. 0 indicates unlimited database size. |
| Trial Length | int |
Number of trial days. The default value is 15. NOTE: Some types of trials may have 0, if the expiration date is fixed and not based on the install date. |
| Expire Date | datetime | Date value (Trial and Term only). |
