SQL Server Performance Forum – Threads Archive

Search for a String Throughout the DATABASE

Hello
I have a Database which contains like 1000 Tables.
I am not the designer of that DB.So I need to in which table and which column
that string exists. IS there a DBWIDE String search possible?
Thanks and Regards

---

Refer to this thread:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12843 Specifically, the link that contains the solution was posted by Madhivanan:
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

---

Also try
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm Madhivanan Failing to plan is Planning to fail

---

thanks Madhivanan and Tahsin.
That is wonderful Link.
It did the Trick for me. Regards

---

]]>