Recursive Trigger not Firing.

• k man

  SSC-Addicted

  Points: 432

  More actions

  October 16, 2008 at 7:30 am

  #125218

  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?