Posted By

edwinet on 04/23/13


Tagged

sql query trigger


Versions (?)

Viewing Trigger Order (First and Last)


 / Published in: SQL
 

URL: 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.

  1. SELECT name TriggerName,
  2. ROW_NUMBER() OVER (ORDER BY modify_date DESC) ExecutionOrder
  3. FROM sys.triggers
  4. WHERE parent_id = object_id('Table-test')
  5. ORDER BY modify_date DESC

Report this snippet  

You need to login to post a comment.