For this kind of occasional search it is reasonable to kind of ignore performance. This is not the kind of thing we do regularly. The concern for me is that sp_MSforeachdb will sometimes skip databases. This can cause all sorts of problems. Here are a couple of posts for alternatives to the undocumented and occasionally failing MS version.
https://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/
http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx
And since this only searching the definition of objects I would suggest that using SQL Search from Redgate (this forum's sponsor) is a better option. It is a free SSMS plugin that works fabulously for this type of thing. You can it here. http://www.red-gate.com/products/sql-development/sql-search/
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/