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.

If you're using SQL Server 2005, wouldn't you do better to search sys.sql_modules?  That's the replacement for syscomments.  The definition column holds all the sql definitions, and is nvarchar(max).

I imagine the object_definition() function simply queries that view, so you should get better performance by searching the view directly rather than using the function.