Simple block of SQL that will let you find a particular text needed sometimes like when you want to observe which procs are deleting data or which are setting particular column to some particular value so this is quite handy in that case :
Ist a simple SQL block and goes as
SELECT Distinct sysobjects.Name
FROM sysobjects JOIN syscomments
on sysobjects.Id = syscomments.ID AND sysobjects.Type = 'P'
AND Text LIKE '% delete %'
ORDER BY sysobjects.Name
you can modify it a bit as per your requirements.