select distinct object_name(id) as 存储过程名 from syscomments where text like'%要查的字符%'and id in(select object_id from sys.objects where type='p')
这方法只能查未加密的存储
已加密的存储过程请先都用工具解密
