List of triggers, SQL Server 2000

[dgillz]

In SQL Enterprise Manager, I can right click a table and go to tasks, manage triggers. However, I don't really feel like do this to 500 tables. Is there no way to get a list of triggers in SQL Server 2000?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[yelworcm]

you could use this as a start:

select object_name(parent_obj), name
from sysobjects
where type = 'TR'