|
|
| John Longstreet 2005-11-17, 3:24 am |
| 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
| |
|
|
| --CELKO-- 2005-11-17, 8:24 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.
| |
| John Longstreet 2005-11-17, 8:24 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.googlegroups.com...
> Hi John,
>
> try this one:
>
> http://vyaskn.tripod.com/ search_al..._all_tables.htm
>
> HTH, Jens Suessmeyer.
>
| |
| John Longstreet 2005-11-17, 8:24 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.googlegroups.com...
particular value ? <<[color=darkred]
>
> 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.
>
| |
| John Longstreet 2005-11-19, 3:23 am |
| 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.
>
|
|
|
|