select name 
from sysobjects o, syscomments s 
where o.id = s.id 
and text like '%CASIGN%' 
and o.xtype = 'P'

快速查找所有存储过程中是否包含某个字符串

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄