using record by record update

When there is a need for performing updates into MF a record at a time then the following procedure can be used. This is only used in exceptional cases where complex update issues need to be resolved

Declare @SessionID int
exec spMFUpdateItemByItem @TableName = 'MFOtherDocument', @SessionIDOut = @SessionID output
Select @SessionID

-- SHOW THE STATUS OF EACH OBJECT IN THE TABLE AUDIT HISTORY
select * from MFAuditHistory where SessionID = @SessionID