SELECT name TriggerName,
ROW_NUMBER() OVER (Order by modify_date Desc) ExecutionOrder
FROM sys.triggers
WHERE parent_id = object_id('Table-test')
ORDER BY modify_date DESC

http://sqlservernet.blogspot.com/2012/01/viewing-trigger-order-first-and-last.html

This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

Viewing Trigger Order (First and Last)

sql, query

SQL