Hi! I am not new to SQL but I am new to using T-SQL and the system tables.

I inherited a SS2K database that is fairly extensive. I need to examine the SQL coding of all triggers in all instances of the datbase. I have Enterprise Manager, but it would be a lengthy process to open all tables of all instances to examine the SQL coding.

I am able to query system tables but I don't know their schema well enough to do find the information I need.

QUESTION: is there a T-SQL query I can write to find all triggers in the SS group and list the following?

- Instance name
- Table name
- Trigger name
- SQL code that makes up the trigger

Any help you can provide would be greatly appreciated!

-- Tom

__________________
--- Tom

Look at sysobjects table/view and xtype/type column.