TODO:
Have you ever wanted to find text that exists in a stored procedure, function or trigger using T-SQL?
SOLUTION:
SELECT DISTINCT *
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%enter your search criteria here%'
ORDER BY 2,1
NOTES:
There are no notes on this topic.