Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Configure Log Shipping Guide

xp_sqllitespeed_licenseinfo

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.

Syntax

EXEC master.dbo.xp_sqllitespeed_licenseinfo
[ @licensekey = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX-111-22222-YY'
, @sitemessage = 'Site_Message'
[, @store = 1]
| @remove = 1]

Arguments

@licensekey

Passes license key value.

@sitemessage

Passes license site message.

@store = 1

Overwrites any currently stored licenses with the valid license supplied.

@remove = 1

Removes the currently stored license.

Examples

  1. View information about the supplied license key:

    EXEC master.dbo.xp_sqllitespeed_licenseinfo
    @licensekey = 'C20TM3Q3K2HD74UDLBMHC6KYV6HZ3MQFNXZFB-123-45678-34'
    , @sitemessage = 'Trial Version'

  2. Register a license key:

    EXEC master.dbo.xp_sqllitespeed_licenseinfo
    @licensekey = 'C20TM3Q3K2HD74UDLBMHC6KYV6HZ3MQFNXZFB-123-45678-34'
    , @sitemessage = 'Trial Version'
    , @store=1

  3. Remove license key:

    EXEC master.dbo.xp_sqllitespeed_licenseinfo
    @remove= 1

Result Set

Column Name Data Type Description
Product Name nvarchar(128) LiteSpeed for SQL Server.
License Key nvarchar(128) Key license value.
License Site Message nvarchar(128) Site message.
License Type nvarchar(128)

One of the following:

  • Trial—a dated trial license key that expires on a specific date
  • Permanent—a permanent license key
  • Term—similar to trial keys, except it comes with support
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).
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating