If I have multiple triggers for an INSERT operation on a table. Is there a way to set the order of the triggers? Is there a way to say run this trigger before this one? I cannot combine the triggers.
www.aspfree.com wrote: Exec sp_settriggerorder @triggername = 'trInventory_I', @order = 'first', @stmttype = 'INSERT' The @order parameter must have one of these values: ‘first’, ‘last’, or ‘none’. The value ‘none’ is used to reset the order of the execution of the trigger after it has been specified. The @stmttype parameter must have one of these values: ‘INSERT’, ‘UPDATE’, or ‘DELETE’. Since only one Instead-of trigger can be associated with a table, and since it is executed before any other trigger (or constraint), it is not possible to
Exec sp_settriggerorder @triggername = 'trInventory_I', @order = 'first', @stmttype = 'INSERT'
The @order parameter must have one of these values: ‘first’, ‘last’, or ‘none’. The value ‘none’ is used to reset the order of the execution of the trigger after it has been specified. The @stmttype parameter must have one of these values: ‘INSERT’, ‘UPDATE’, or ‘DELETE’.
Since only one Instead-of trigger can be associated with a table, and since it is executed before any other trigger (or constraint), it is not possible to