Looking for a tool for data mining 1

[Veneficus]

Hi Techies,

I am looking for a tool that would go through all the fields of all the tables in a database (SQL in my case) and search for a specific string and give me a list that which tables and fields have that info.

I can write something to accomplish this but I bet there is a product out there that would do what I want to do.

Do you aware of any product that accomplishes what I ask for?

 

[cheyney]

Here is a link to a stored procedure definition that does this:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Cheyney

 

[Veneficus]

Wow. This is sweet. Saved me tons of time.

Thanks a lot,
Ven