Hi all,

This post is about how to find a STRING in stored procedures and triggers.
This tip is VERY useful for those who works with T-SQL.

code
select distinct(object_name(id)) from syscomments
where
text like ‘%string%’

example
select distinct(object_name(id)) from syscomments
where
text like ‘%mytable%’

see ya😀