How can I found out Field Name and Table which contain certain value?

[srkk]

Hi,

How can I found out Field Name and Table which contain certain value?

For example, I have Customer Code of "AA1100", but the problem i need to search through whole database to find out which table and field that contain this value, is it possible to do this in MS SQL 2000?

edm

 

[vongrunt]

Yes, with dynamic SQL and some crawling over metadata (system tables).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[srkk]

Any coding example?

edm