Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - Security and Compliance 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' ]
[, @ShowLicenseNumber = 1 ]
[, @store = 1]
| @remove = 1]

Arguments

@licensekey

Passes license key value.

@sitemessage

Passes license site message. Applicable to upgrades from a LiteSpeed 8.5 or earlier installation.

@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.

Examples

  1. View information about the supplied license key:

    EXEC master.dbo.xp_sqllitespeed_licenseinfo
    @licensekey = 'C20TM3Q3K2HD74UDLBMHC6KYV6HZ3MQFNXZFB-123-45678-34'

  2. Register a license key (overwrites any the currently stored licenses):

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

  3. Remove license key:

    EXEC master.dbo.xp_sqllitespeed_licenseinfo
    @remove= 1

  4. View information about the supplied license key (upgrades from a LiteSpeed 8.5 or earlier installation):

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

  5. Register a license key (upgrades from a LiteSpeed 8.5 or earlier installation) (overwrites any the currently stored licenses):

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

  6. 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

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. Applicable to upgrades from a LiteSpeed 8.5 or earlier installation.
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 that are 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 Topics

About Using Extended Stored Procedures

LicenseInfoCmd Utility

License Registration

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating