How to find all triggers on a database

[riksweeney]

Hopefully this one will be nice and easy:

How do I find all the triggers that exist on a database? Is is possible to write a SELECT statement to do it?

Thanks

Richard Sweeney

 

[JamesLean]

USE db_name

SELECT * FROM sysobjects
WHERE xtype = 'tr'

--James

 

[JamesLean]

Also, this one will give you the table names as well:

SELECT o.name AS triggername, p.name AS tablename
FROM sysobjects o JOIN sysobjects p ON o.parent_obj = p.id
WHERE o.xtype = 'tr'

--James

 

[riksweeney]

Fantastic

Thanks a lot

Richard Sweeney