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