Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 24, 2012 10:51 AM by Chen Yu - MSFT
Apr 20, 2012 05:56 PM|LINK
Apr 20, 2012 07:02 PM|LINK
It is depend upon you where u set the trigger and start the trigger
Apr 20, 2012 07:08 PM|LINK
that's the things i want to find out,
right now, i have a table and some triggers created by someone else, i don't know that execution order of those triggers(maybe someone set the order, maybe not, i don't know),
is there a way to find out the order....
Apr 20, 2012 07:10 PM|LINK
Check this article out
Apr 20, 2012 07:30 PM|LINK
thanks for the reply, i saw that post as well,
i don't want to set the order, all i want is to see what the current execution order is for those triggers
Apr 21, 2012 04:39 AM|LINK
you can trace this(all excucation of any DB) by using "SQL Server Profiler".
Apr 23, 2012 04:48 PM|LINK
can you be more specific?
Apr 24, 2012 10:51 AM|LINK
Please check below query, if is_first and is_last is zero, and they have same type_desc, triggers execution orderd by modify date.
from sys.triggers inner join sys.trigger_events
on sys.trigger_events.object_id = sys.triggers.object_id
inner join sys.tables on sys.tables.object_id = sys.triggers.parent_id
order by modify_date