NEWBIE AND EASY QUESTION

Hi,
Sorry for my poor english. I'm a newbie in SQL Server, and I want to know if
it's possible (and How :)) i can find a string of text in all tables of a
SQL Database.
I explain my problem for easy understanding:
I have a form that submit data in to a SQL database and I want to know
in wich table does it goes... I inserted a simple text on a form's field
(ex. ABCDEFG) now I want to search every table until i find that string.
Thanks,This isn't that easy to do as it might sound. I suggest you run Profiler and catch the statement the
app submits and inspect that INSERT statement. In return, you will learn to use the very valuable
Profiler tool!
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joao Bras - Brasmatica" <no@.spam.com> wrote in message
news:%237fAUjNoEHA.3896@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Sorry for my poor english. I'm a newbie in SQL Server, and I want to know if
> it's possible (and How :)) i can find a string of text in all tables of a
> SQL Database.
> I explain my problem for easy understanding:
> I have a form that submit data in to a SQL database and I want to know
> in wich table does it goes... I inserted a simple text on a form's field
> (ex. ABCDEFG) now I want to search every table until i find that string.
> Thanks,
>|||This should help you:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
--
David Portas
SQL Server MVP
--|||Thank you for all the answers. Special Thanks for David Portas (are you
portuguese?) It worked wonderfully. Tibor Karaszi, thank you, for your
promptly help.