--How To Search The Text of Stored Procedures in SQL Server:

SELECT OBJECT_NAME(id)

    FROM syscomments

    WHERE [text] LIKE '%foobar%'

    AND OBJECTPROPERTY(id, 'IsProcedure') = 1

    GROUP BY OBJECT_NAME(id)