How to know what are the tables have triggers from database?

asked Dec 04 '11 at 06:23 AM in Default

Naren
27 ● 15 ● 18 ● 19

(comments are locked)

2 answers:

You'll need to look in either sys.objects where type = 'TR' and get the parent_object_id

or sys.triggers and get the parent_id

answered Dec 04 '11 at 10:39 AM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

(comments are locked)

you can find the trigger details in sys.triggers . to determining dependencies for a specific trigger check sys.sql_expression_dependencies system catalog

answered Dec 04 '11 at 10:40 AM

salum
213 ● 1

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

sql-server-2005 x1834
trigger x98
dba x66

asked: Dec 04 '11 at 06:23 AM

Seen: 470 times

Last Updated: Dec 04 '11 at 11:53 AM

How to know what are the tables have triggers from database?

Follow this question

Related Questions