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