K2BAudit.SynchAuditTriggers procedure

By default all tables that are marked as audited in an application are actually audited at run time. The application user, however, can suspend and later turn on audit for selected tables at run time if he/she has access to K2BAudit.WorkWithAuditTriggersMain web panel.

K2B Audit keeps track of what tables are actually audited in it's own tables structure.

If, for some reason, database triggers are lost, turned off, etc. outside K2B Audit, the SynchAuditTriggers can synchronize actual triggers in the database with the information kept by K2B Audit.

The SynchAuditTriggers removes any audit trigger that may exists on tables with suspended audit and adds audit triggers to those with active audit.