SQL Server Performance Forum – Threads Archive

Searching a word in over all db server

I have a word which exist in a table located in a db.We dont have any information neither the name of db nor the table name.Is it possible in any way to determine the tablename in which this word is located.
Any tool or script by which I can do so?

---

See if this helps you
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
Madhivanan Failing to plan is Planning to fail

---

i love that script- has helped me out mant a time! ‘I reject your reality and substitute my own’ – Adam Savage

---

]]>