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