SQLTeam.com | Weblogs | Forums

Trigger execution order


#1

i have a table on which i have created 5 triggers. i need to sort triggers order so that they can execute according to some order, but in sql server i did not find any way to order more than 3 triggers. please help.


#2

why do you need to have 5 different trigger on the same table ? You can only set trigger order as FIRST , LAST or NONE. The only option you have to is to combine your trigger code


#3

If you show the triggers we may be able to help explain how and why to combine them.


#4

You can specify only first and last. The remaining triggers can fire in any possible order.