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.
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
If you show the triggers we may be able to help explain how and why to combine them.
You can specify only first and last. The remaining triggers can fire in any possible order.