学步园

select distinct(so.name) as name
from syscomments sc inner join sysobjects so
on sc.id = so.id 
where so.xtype = 'P'

and sc.text like '%sproc_name%'

原文路径：

http://blog.chinaunix.net/uid-11209572-id-3273211.html