some time we need to find the text in all procedures in SQL Server, the following qurey is helpful for finding the text in Procedures.
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
SO.Type = ‘P’
SC.Text LIKE ‘%text%’