Advanced Search

Viewing Trigger Order (First and Last)

/ Published in: SQL
Save to your folder(s)
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.