How to view all triggers in a db

[IanStrange]

Hi
I am looking for a way to see all the triggers currently on every table in one database.
Is there some bdcc I can use or clever select statement on one of the system tables.
Thanks
Ian

No man is an island but 6 tied together make quite a good raft.

 

[JamesLean]

Either the undocumented SP sp_msforeachtable or query the sysobjects table:

EXEC sp_msforeachtable 'EXEC sp_helptrigger [?]'

select tbl.name as table_name, tr.name as trigger_name
from sysobjects tr join sysobjects tbl on tr.parent_obj = tbl.id
where tr.type = 'tr'
order by tbl.name

--James

 

[IanStrange]

Thanks very much exactly what I needed.

No man is an island but 6 tied together make quite a good raft.