Today I need to make changes in trigger but I forgot the name of trigger and associated table with it.
So quickly find out the list of triggers associated with the tables in a database, I used following query.
SELECT [Name] AS TriggerList,
OBJECT_NAME(parent_id) AS TableList,
create_date AS CreatedDate,
modify_date AS ModifiedDate
FROM sys.triggers ORDER BY [Name]
Note: I have tested this query only in SQl Server 2005.