Re: Database Triggers

John, I use triggers for auditing. Every time an insert/update/delete occurs I write out to an audit table. This is done via triggers. the advantage of this to having the app do it is that ad hoc updates are also recorded and a developer can't slip something into production that does not audit. I also use triggers to enforce denormalisation decisions if at al possible. Regards David Ashby ______________________________ Reply Separator _________________________________ Hi, I'm currently doing a project on Active Database Systems and I am interested to know if anyone actually implements triggers within their database systems and what they find them most useful for?. I'm also interested to know of any problems encountered with using triggers. Any feedback would be very grateful, Thanks, - john