Use the following small script to find all hidden triggers in a SQL Server database. Pretty much all competent developers using SQL agree that using triggers is a bad practice, but few know how to find them before they have wasted a lot of development and testing time not understanding why things aren’t working the way they want them to (because of triggers doing behind the scenes work, undesirably).
-- Finds all "hidden" triggers in a database. Using triggers is not a best practice. USE <database_name>; GO SELECT name AS [TriggerName] FROM sys.objects WHERE OBJECTPROPERTY(object_id, 'IsTrigger') <> 0;