Return to Snippet

Revision: 63284
at April 23, 2013 01:11 by edwinet

Initial Code
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

Initial URL

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

Initial Title
Viewing Trigger Order (First and Last)

Initial Tags
sql, query

Initial Language