Global search on a databse

Hi Newsgroup,
is there a possibility to do a global search on a wohle mssql-database to
find a specific text string?
I know for sure that there is a specific text string as plaintext (or maybe
as binary value) somewhere in a column in one of the tables - I just dont
konw in which table in which column ;-(
is there an option to do a global search on all tables of a database?
I'll appreciate any help!
Best, JanHi Jan,
no need to cross language post :-)
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Vyas has a procedure for the same.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Jan Meier" <no@.no.com> wrote in message
news:%23F9zmaIWGHA.3660@.TK2MSFTNGP04.phx.gbl...
> Hi Newsgroup,
> is there a possibility to do a global search on a wohle mssql-database to
> find a specific text string?
> I know for sure that there is a specific text string as plaintext (or
> maybe as binary value) somewhere in a column in one of the tables - I just
> dont konw in which table in which column ;-(
> is there an option to do a global search on all tables of a database?
> I'll appreciate any help!
> Best, Jan
>