dstjohnjr
asked on
SQL Query to search for a specific value in a database where table and field names are unknown
I have a rather large database that contains about 3500 tables. I have a specific value that exists in one of the fields in side one of the tables but don't have a clue as to which table, much less field. Is there a way to mine this data using some sort of a SQL query? Consequently, the value I am searching for is 200611.
TIA for any guidance at all!
Oh, and this is for SQL Server 2000.
TIA for any guidance at all!
Oh, and this is for SQL Server 2000.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER