If we have multiple AFTER Triggers on table how can we define the sequence of the triggers

Q

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?

✍: Guest

A

If a table has multiple AFTER triggers, then you can specify which trigger should be executed first and which trigger should be executed last using the stored procedure sp_settriggerorder. All the other triggers are in an undefined order which you cannot control.

2007-10-25, 7119👍, 0💬