I just learn to set the priority of the triggers to be fired and came across with one system stored procedure which can be used to set force orders of DML and DDL triggers.
@triggername = 'TriggerName' -- Trigger Name
@order = 'FIRST' -- First | Last
@stmttype = 'UPDATE' -- Insert | Update | Delete
Here is small explaination how triggers prioritized.
Actually i was believe as we can set orders in first, second, third and so on. But we can set them with First and Last priority only. We can not manage orders of more than three triggers at all.
SQL Server Tips · · · ·
This saved a holiday for me once :)