Ever wanted to know what triggers exist on a database? The script below will produce a list of all the triggers on the current database, and also what table they are linked to.
SELECT Name AS TriggerName, OBJECT_NAME(parent_object_id) AS TableName FROM sys.objects WHERE type='TR'
