How to know what are the tables have triggers from database?
Dec 04, 2011 at 06:23 AM
Dec 04, 2011 at 11:53 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 ♦♦
Dec 04, 2011 at 10:41 AM
you can find the trigger details in sys.triggers . to determining dependencies for a specific trigger check sys.sql_expression_dependencies system catalog
Dec 04, 2011 at 10:40 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
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: 1114 times
Last Updated: Dec 04, 2011 at 11:53 AM
Database And Trigger
Any one help me out the scripts for daily health checkup?
Mean time to recovery docs?
Variables possible in this trigger?
Regarding particular table and index sizes,rowcounts?
INSTEAD OF trigger
How to know job when statred when completed and how much time it is running?
DDL Audit Trigger Security
How to move the indexes to new file group?
Logshipping issue 2005 to 2014 in no recovery mode