Firing of a delete trigger within an insert/update instead of trigger 1

[carolx]

Need some help on instead of triggers. I created an instead of trigger for insert/update on a table called transactions. I created a separate instead of delete trigger on the same table. If I execute insert or update on the table and then try to delete records from the table within the trigger the delete trigger is not fired but the records are deleted anyway. What is happening here.

Carolx

 

[markros]

Take a look at Using Nested Triggers topic in BOL. You may want to configure recursive triggers to be on for your database

PluralSight Learning Library