搜索存储过程中的信息

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