Hello,
I think the example is not the luckiest as once you have a stored proc that deletes the record it could take care of the auditing part as well.
Adding auditing to a DB where DMLs commands are not wrapped into storedprocs is more tricky.
Áron-Hungary