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

punjabtechnicaluniversity.blogspot.in

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.