Search Find a text in all stored procedures in all database in one go

http://www.databasejournal.com/scripts/search-all-stored-procedures-in-all-databases.html

EXEC sp_MSForEachDB 

 'USE ?; 
SELECT DB_NAME(), ROUTINE_NAME 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE ''%foobar%''
    AND ROUTINE_TYPE = ''PROCEDURE'''