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

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