spMFDeploymentDetails

Signature

EXEC dbo.spMFDeploymentDetails
    @Int = 0,
    @ProcessBatch_ID = NULL OUTPUT,
    @Debug = 0;
Returns

  • 1 = Success

  • -1 = Error

Parameters
@Int (optional)
used as input variable to set the type of update message

0 - default message -1 - Failed

@ProcessBatch_ID int (optional, output)

Referencing the ID of the ProcessBatch logging table

@Debug smallint (optional)

  • Default = 0

  • 1 = Standard Debug Mode

  • 101 = Advanced Debug Mode

Purpose

Print deployment details

Examples

EXEC dbo.spMFDeploymentDetails

Changelog

Date

Author

Description

2026-07-29

AC

Widen ASSEMBLYPROPERTY version-string casts from NVARCHAR(3) to NVARCHAR(10) (VersionMajor/Minor/ Build/Revision, both LSConnectMFilesAPIWrapper and Interop.MFilesAPI, in both the MFDeploymentDetail INSERT and the PRINT summary). NVARCHAR(3) silently assumed every version component fits in 3 digits; LSConnectMFilesAPIWrapper 5.38.9638.21235 has a 4-digit Build and 5-digit Revision, which raised Msg 8115 “Arithmetic overflow error converting expression to data type nvarchar” (Issue #41, 5.13.38.82 Stage 40 Test 2)

2024-08-17

AC

Fix Last Release Number not returning correct value

2023-06-26

Lc

Improve logging

2021-09-11

LC

Add parameter to set type of update

2019-08-30

JC

Added documentation