Find a procedures having a particular text to be searched in.

SELECT ob.id,ob.name
FROM sys.sysobjects AS ob INNER JOIN
sys.syscomments AS comm ON ob.id = comm.id
where ob.xtype='P' and ob.uid=1 and comm.text like '%(list%'