SQL Server中查找包含某个文本的存储过程

SELECT name,text from sysobjects o,syscomments s 

where o.id=s.id and text LIKE '%text%' and o.xtype='p'