Dec 04, 2011 at 06:23 AM
Dec 04, 2011 at 11:53 AM
Dec 04, 2011 at 10:40 AM
Dec 04, 2011 at 10:41 AM
You'll need to look in either sys.objects where type = 'TR' and get the parent_object_id
where type = 'TR'
or [sys.triggers] and get the parent_id
Dec 04, 2011 at 10:39 AM
Kev Riley ♦♦
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Dec 04, 2011 at 06:23 AM
Seen: 897 times
Last Updated: Dec 04, 2011 at 11:53 AM
Any one help me out the scripts for daily health checkup?
clr store procedure call from trigger.
Trigger Not Firing Sometimes
temporary tables, triggers, transactions, "database session"
Regarding particular table and index sizes,rowcounts?
Mean time to recovery docs?
Database Triggers and commit
Database And Trigger
How to know job when statred when completed and how much time it is running?
Variables possible in this trigger?