Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Recursive Trigger not Firing. Expand / Collapse
Posted Thursday, October 16, 2008 7:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 6:07 AM
Points: 227, Visits: 138
I have an "Instead of Delete" trigger on a table. What this trigger does is actually performs an Updated on the table. The idea is that this update would then fire the 'Instead of Update' trigger that is also present on the same table. It is here that the necessary actions would be completed on the table.
I am having issue with the Delete trigger actually completing the update, but the Update trigger never firing. The Delete trigger should never complete the update, instead it should set of the Instead of Update trigger.
From BOL it seems like the "INSTEAD OF" triggers should work recursively regardless of the NESTED TRIGGER option on the Server. (which is set to 1 anyway)
I have also set the Database level 'Recursive trigger option' to 1. Still the Update Trigger will not fire when the Delete Trigger does an update.

Any idea of what could be preventing the update trigger from working?
Post #586953
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse