Friday, February 24, 2012

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, JanVyas has a procedure for the same.
http://vyaskn.tripod.com/search_all..._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
>

No comments:

Post a Comment