List of Tables used in all the Triggers

[manmaria]

Is there a way to identify the list of tables used in all the triggers?

TIA

 

[manmaria]

I think this will work

select distinct x.name from sysobjects x
inner join
(
select a.name, b.text
from sysobjects a inner join syscomments b
on a.id = b.id

where a.xtype = 'TR'
) z
on charindex(x.name, z.text) > 0
and x.xtype = 'U'

 

[tlbroadbent]

You should be able to use the sysdepends table to identify dependencies as in this query.

SELECT DISTINCT triggername = trg.name, tblname = tbl.name
FROM sysobjects trg
JOIN sysdepends dep
	ON trg.id = dep.id
JOIN sysobjects tbl
	ON dep.depid = tbl.id
WHERE trg.type = 'tr'
ORDER BY 1,2

Terry L. Broadbent - DBA

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. (Nathaniel Borenstein)