This isn't as "pretty" as the "Search all tables" from the parent message, but it does work:

SELECT *
FROM sys.sql_modules
WHERE definition LIKE '%SearchTerm%'

Also, if you're doing a lot of searching, there's a free plugin for SSMS from RedGate called SQL Search that's completely free and does even better than both of these techniques.