方法1.
打开数据库管理界面->右击数据库->tasks->Generate Scripts->.....
导出所有存储过程到文件中，然后ctrl+F查找
方法2.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%text%‘ AND ROUTINE_TYPE=‘PROCEDURE‘
方法3.
select name from sysobjects o, syscomments s where o.id = s.id and text like ‘%text%‘ and o.xtype = ‘P‘
原文：http://www.cnblogs.com/jiyang2008/p/7730259.html