I recently was examining source code and used a different technique. I believe the following will accomplish the same thing in SQL 2005. I do not know if it works in SQL 2000.

SELECT OBJECT_NAME(object_ID) AS Name, definition

FROM sys.sql_modules

WHERE definition LIKE '%YourSearchString%'