The text of all stored procedures is store in the syscomments table. You can search for a specific string with a query like this:

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE text LIKE '%search_string%'

-Mike