spMFInsertLoginAccount

Signature

EXEC dbo.spMFInsertLoginAccount
    @Doc = N'<xml>',
    @isFullUpdate = 1,
    @Output = NULL OUTPUT,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Doc

• Type: NVARCHAR(MAX)

• Required: Yes

• Description: Listing of login accounts (XML).

@isFullUpdate

• Type: BIT

• Required: Yes (always 1)

• Description: Full update flag.

@Output

• Type: INT

• Required: No (OUTPUT)

• Description: Update result.

@Debug

• Type: SMALLINT

• Required: No (default = 0)

• Description: Debug level. - 1 = Standard Debug Mode

Purpose

The purpose of this procedure is to insert Login Account details into MFLoginAccount table.

Changelog

Date	Author	Description
2023-10-12	LC	Update to insert or update changes and set deleted flag for deleted items
2019-08-30	JC	Added documentation
2017-08-22	LC	Add insert/update of userID as MFID column