I had the same task recently and I used the following for SQL Server 2012 db. Use management studio and connect to the database you want to search. Then execute the following script for list of all triggers in SQL Server database with table name and table’s schema.

For SQL 2000

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.