spMFGetLicense¶

Returns

1 = Success
-1 = Error

Parameters

@ModuleID nvarchar(10)

Module identifier to check

@ExpiryDate datetime (output)

Expiry date; returns NULL if not available

@CheckStatus int (output)

Pre-check status code

@Status nvarchar(100) (output)

Human-readable status text

@Errorcode nvarchar(10) (output)

Internal error code, when applicable

@Debug smallint (optional)

Default = 0
1 = Standard Debug Mode

Purpose¶

Internal helper used by the license validation routine spMFCheckLicenseStatus. Executes the module validation and returns an interpreted result set via output parameters.

Examples¶

 DECLARE @ExpiryDate DATETIME,
   @Errorcode  NVARCHAR(10),
   @CheckStatus INT,
   @Status     NVARCHAR(100);

 EXEC dbo.spMFGetLicense
@ModuleID    = 1,
@ExpiryDate  = @ExpiryDate OUTPUT,
@Errorcode   = @Errorcode OUTPUT,
@CheckStatus = @CheckStatus OUTPUT,
@Status      = @Status OUTPUT,
@Debug       = 0;

 SELECT @ExpiryDate AS ExpiryDate,
  @Errorcode  AS Errorcode,
  @CheckStatus AS CheckStatus,
  @Status     AS Status;

Changelog¶

Date	Author	Description
2025-01-07	LC	add culture check in datetime formatting
2024-12-31	LC	add additional variations of converting datetime for license
2024-12-13	LC	add additional debugging
2024-03-25	LC	add try catch on expriy date conversion to deal with different formats
2024-02-02	LC	remove time from expiry date
2023-09-04	LC	remove try catch block for validating expiry date
2022-02-24	MA	Fix date delimiter bug to pass in fnMFTextToDate funtion
2021-04-08	LC	Add check to validate connection
2021-01-06	LC	Fix bug with checking module 2 license
2020-12-04	LC	Create procedure to aid spMFChecklicense status