|
We have an application where rows are mysteriously deleted off a single table. Vendor claims it isn't their code and application folks claim they didn't do it. I used a delete trigger to insert the data being deleted to another table. When the delete inadvertantly happens, the deleted records are at least logged somewhere. The application team has a quick way to restore the missing data back into the original table. Is there a way to capture what ID is actually performing the delete in the trigger?
|