SELECT  ROUTINE_NAME, ROUTINE_DEFINITION 
FROM    INFORMATION_SCHEMA.ROUTINES 
WHERE   ROUTINE_DEFINITION LIKE '%foobar%' 
        AND ROUTINE_TYPE='PROCEDURE'

SQL Server - Find text in stored proc

sql

SQL