sql server replication: List all triggers for a table or an entire database -- sql server replication

List all triggers for a table or an entire database

Troy
3/29/2006 1:41:10 PM

sql server replication:

How can I get a list of all the triggers associated with a particular
table in a database. And in addition, how can I get a list of all
triggers for the entire database (meaning all triggers associated with
all tables)? Thanks!!

--

Regards,

Re: List all triggers for a table or an entire database

Troy
3/29/2006 1:47:59 PM

Troy,

[quoted text, click to view]

answered my own question... here's the query in case someone else is
wondering:

SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S1.deltrig
[quoted text, click to view]
THEN 'Update' END 'TriggerType' FROM sysobjects S1 JOIN sysobjects S2 ON
S1.parent_obj = S2.[id] WHERE S1.xtype='TR'

--

Regards,