SQL 查询存储过程

select distinct name 
from syscomments a,sysobjects b 
where a.id=b.id and b.xtype='p' --and text like '%my_sp%'