根据内容模糊查询存储过程
方法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'