can I trust Triggers?

[jrahma]

Hi,

I am currently using stored procedures to do an action after my INSERT, UPDATE or DELETE.

I just wanted to ask for your advise..

do you recommend to continue using the stored procedures or start using triggers?

my simple example is an event-log table... I insert a row in this table if a row was inserted in employees table.

Thanks,
Jassim

[NogDog]

Well, you can call a stored procedure via a trigger. 🙂 (Which I do with good results on a project here at work)

[bradgrafelman]

Triggers versus... what? An external application that hopefully is honest enough to always do this action after an INSERT, UPDATE, or DELETE? Yeah, I'd trust a trigger a lot more than that.

At least, I'd trust the DBMS to do the trigger as much as I trust it will insert data when I send it an INSERT query.