查找包含指定字符的Sql存储过程

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