3
Search Trigger Text SQL Server 2005
How to search if a trigger contains certain text in SQL Server 2005:
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE ‘%your_search_here%’ AND OBJECTPROPERTY(id, ‘IsTrigger’) = 1
GROUP BY OBJECT_NAME(id)