SEO

#1 (**permalink**) 02-29-2008, 01:56 PM

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

#2 (**permalink**) 02-29-2008, 01:56 PM

Hi John,

try this one:

http://vyaskn.tripod.com/search_all_...all_tables.htm

HTH, Jens Suessmeyer.

#3 (**permalink**) 02-29-2008, 01:57 PM

>> Is there any easy method to search all tables in a given database for a 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.

#4 (**permalink**) 02-29-2008, 01:57 PM

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.googlegro ups.com...
> Hi John,
>
> try this one:
>
> http://vyaskn.tripod.com/search_all_...all_tables.htm
>
> HTH, Jens Suessmeyer.
>

#5 (**permalink**) 02-29-2008, 01:57 PM

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.googlegr oups.com...
> >> Is there any easy method to search all tables in a given database for a
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.
>

#6 (**permalink**) 02-29-2008, 01:58 PM

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.googlegro ups.com...
> Hi John,
>
> try this one:
>
> http://vyaskn.tripod.com/search_all_...all_tables.htm
>
> HTH, Jens Suessmeyer.
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

need help