Search All Stored Procedures in a Database

declare @searchString varchar(100)

Set @searchString = '%' + 'DtgSchemaOBJECT' + '%'

 SELECT Distinct SO.Name
 FROM sysobjects SO (NOLOCK)
 INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
 AND SO.Type = 'P'
 AND SC.Text LIKE @searchString
 ORDER BY SO.Name