How to check last firedtriggered ?

Question

Post reply

How to check last firedtriggered ?

Bhuvnesh

SSC Guru

Points: 59351
More actions
September 10, 2008 at 12:35 am

#96395

i want to check last fired trigered
is there any sys table or DMV available in sql 2k5 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

sumit kende SSC Veteran Points: 272 More actions · Answer 1

select objectproperty(object_id('NameOfTrigger'),'ExecIsLastInsertTrigger')

gives result as '0' if not or '1' if yes

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

Thanks..............

BUT

what else information we can have .? ....like who exected it ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

sumit kende SSC Veteran Points: 272 More actions · Answer 3

Triigers have specific order for execution, we can change it by :

sp_settriggerorder 'TriigerName', 'LAST', 'INSERT'

see help for OBJECTPROPERTY in MSDN for more details.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 4

Actually i m new DBA

i want to track which developer is playing with DML trigger

i want to get as much as infor about him (what he did with trigger)

DDL trigger can be monitored with eventdata function but not DML ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Please don't cross post. It just wastes people's time and fragments replies.

Markus answered your question over here:

http://www.sqlservercentral.com/Forums/Topic566620-146-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 6

Sorry .......gilamonster

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

thanks...i did the task.....thanks again:):)

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)