select object_name(s.object_id)存储过程名,
       definition
from sys.sql_modules s inner join sys.procedures p
on s.object_id=p.object_id
where definition like '%select name, id from person%'

------解决方案--------------------

SQL code

select a.name,b.text from sys.sysobjects a join syscomments b on (a.id = b.id) 
where a.type = 'p' and b.text like '%你要找的字符串%'