>> 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.