Search in all tables

Within a DB in Enterprise Mgr, how can I search for a phrase within all of the tables?

For example, there may be text that says, "Tangopeer's Homepage". How would I find it?

If the answer is to use SQL Query Analyzer, I couldn't figure it out there, either.

Thanks

First you would have to get a list of all of the tables in the database, then for each of those tables you would have to get all of the fields, then you would have to loop through all of the fields and do a LIKE statement to determine if the text exists within the field.

Sounds, inefficient doesn't it??? That's because it is!

Try doing some filtering or reanalyze your applications needs.
There should never be a reason you would have to do something like this.