Seaching for a matching Text in Stored Procedure SQL Server

I had a rough time, open each stored procedure in my MS SQL Server 2005 and then looking for the text that i needed to change. Then i finally came to a very short query but yet so helpful:

SELECT object_name(id)
FROM syscomments
WHERE text LIKE '%Text%'