Forum Discussion
How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is c...
without actually seeing your triggers, this is difficult to advise on.
My initial thought is that the update of the audit table does not have sufficient constraints, and is copying/logging all rows with the same parent ID.