I created some simpler queries in my blog http://geekatwork.wordpress.com/2010/03/30/database-schema-search/

Search for Text in Stored Procedures

DECLARE @SEARCH_TERM VARCHAR(100)

SET @SEARCH_TERM = ‘%BANKCARD_999%’

SELECT

ROUTINE_NAME,

...