Need to search db for all triggers and list SQL
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!