Posted By

edwinet on 04/23/13


sql query trigger

Versions (?)

Viewing Trigger Order (First and Last)

 / Published in: SQL


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.