Search SQL Server 2005 Stored Procedure Text

How to search the content of stored procedures in a SQL Server 2005 database:

SELECT Name, OBJECT_DEFINITION(OBJECT_ID)
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SEARCH_TERMS%'