How to change the firing order of Triggers?
You can use the following statement to list all triggers in each table.

EXEC sp_MSForEachTable 'PRINT ''?'' 
EXEC sp_helptrigger ''?'''


Once you find out all the triggers. You can manually change the order using  sp_settriggerorder