minimyme (6/9/2010)
I'm a big fan of KIS (keep it simple) principal. If you can avoid the triggers in the first place, absolutely avoid them.
Auditing is normally performed in triggers
1) for security purposes so the action is audited however the action is performed and (pretty much) whoever it is performed by and
2) because the auditing logic is decoupled from the deletion logic.
Dave.