Nice article

The solution I use is to populate a table overnight with the full syscomments text for each object, across multiple databases.  This table can then be queried.  We use an Access front-end for the querying, so we can return a list of matches and then drilldown for a further look into the full text.

An addition I'd like to make is to highlight the search string in the objects, like Google does with search results.  I do like the idea of the line numbering mentioned above too.