查找语句,该怎么处理_Sql Server

查找语句
SQL里有几十个存储过程,我想查找某个语句在哪些存储过程里出现过,有没有办法.
比如select name, id from person
如果一个个存储过程打开然后CTRL+F这样查询的话,太废时间了

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

SQL code

select object_name(s.object_id)存储过程名,       definitionfrom sys.sql_modules s inner join sys.procedures pon s.object_id=p.object_idwhere definition like '%select name, id from person%'
------解决方案--------------------
SQL codeselect a.name,b.text from sys.sysobjects a join syscomments b on (a.id = b.id) where a.type = 'p' and b.text like '%你要找的字符串%'