need help

I am not a DBA and would appreciate any help with the following question

Is there any easy method to search all tables in a given database for a
particular value ?

I am using sql server 200 standard edition


all help appreciated

Thanks

Hi John,

try this one:

http://vyaskn.tripod.com/ search_al..._all_tables.htm

HTH, Jens Suessmeyer.

>> Is there any easy method to search all tables in a given database for a p
articular value ?  <<

This is like saying "The answer is 42!"  without considering that you
need a question that makes sense.   What is the domain of the value?
If you know that, you can determine which tables have a column drwan
from that domain.

Jens

Thank You very kindly
This appears to be exactly what I am looking for
I will give it a try tomorrow

Again Thank You
Very much appreciated

John

"Jens" <Jens@sqlserver2005.de> wrote in message
news:1132215849.264292.48910@g44g2000cwa.googlegroups.com...
> Hi John,
>
> try this one:
>
> http://vyaskn.tripod.com/ search_al..._all_tables.htm
>
> HTH, Jens Suessmeyer.
>

You are far too knowledgeable to waste your time trying to help someone with
little to no experience
However if you read what I asked, you would see that I was asking a question
in strictly
general terms and at the same time stating that I was not a DBA
People seeking help don't generally need a smart AZZ answer
It must satisfy some need within you to demonstrate your superior ability.

So
Your Reply Makes no sense to me
So Thanks I'll take the answer 42 !

GLTY !!!!!!!!!!!!!


"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1132259236.965510.205970@f14g2000cwb.googlegroups.com... 
particular value ?  <<
>
> This is like saying "The answer is 42!"  without considering that you
> need a question that makes sense.   What is the domain of the value?
> If you know that, you can determine which tables have a column drwan
> from that domain.
>

Jens

Tried this today
It is just what I was looking for

Thanks So Much

John
"Jens" <Jens@sqlserver2005.de> wrote in message
news:1132215849.264292.48910@g44g2000cwa.googlegroups.com...
> Hi John,
>
> try this one:
>
> http://vyaskn.tripod.com/ search_al..._all_tables.htm
>
> HTH, Jens Suessmeyer.
>