方法一

select name 

from sysobjects o, syscomments s 

where o.id = s.id 

and text like '%test1%' 

and o.xtype = 'P' 

方法二

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 

FROM INFORMATION_SCHEMA.ROUTINES 

WHERE ROUTINE_DEFINITION LIKE '%test1%' 

AND ROUTINE_TYPE='PROCEDURE' 

返回所有出现过该字符串的存储过程名：