Question

if we have multiple AFTER Triggers on table how can we define the sequence od the triggers?

Answer 1

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.