simon.ellistonball (6/9/2010)
A nice idea, but your trigger relies on the fact that you would only ever delete one product at a time.
No, it doesn't. It does rely on having only one UserID and Reason for a given batch of deletes, and it does rely on context_info being XML, but the trigger as written should properly audit a deletion of multiple records in a batch if the previous conditions are met.