How to Get a particularize Text in SQL Server Stored Procedure (search Text on store procedure)

Recently I come across a issue .my one of subordinate getting a bulk mails as he is added his Email Id one of Store procedure for testing purpose and forgot to change with proper email id and now he is forgot to which SP he is added email Id.

For for that SQL 2008 provide the solution to find the Particular text on SP and search.

As

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)

FROM sys.procedures

WHERE OBJECT_DEFINITION(object_id) LIKE '%Text%'