How to know what are the tables have triggers from database?
Dec 04 '11 at 06:23 AM
Dec 04 '11 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 '11 at 10:39 AM
Kev Riley ♦♦
Dec 04 '11 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 '11 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
asked: Dec 04 '11 at 06:23 AM
Seen: 470 times
Last Updated: Dec 04 '11 at 11:53 AM
Database Triggers and commit
Database And Trigger
Any one help me out the scripts for daily health checkup?
Variables possible in this trigger?
Regarding particular table and index sizes,rowcounts?
INSTEAD OF trigger
DDL Audit Trigger Security
sql trigger to email when data input
How to get the SQL code of the DML that fires a trigger?
Differences between SQL Server 2005 and 2008 when updating values
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.