Viewing Trigger Order (First and Last) - SQL Snipplr Social Repository

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

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

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

SQL

Choose a language for easy browsing: