Wednesday, March 28, 2012

Script to search for a string in all varchar columns in all tables in a database?


I have a string which I need to know where it came from in a database.
I don't want to spend time coding this so is there a ready made script
which takes a string as a parameter and searches all the tables which
contain varchar type columns and searches these columns and indicate which
tables contain that string?

Full text search is not enabled.

--
Tony
http://dotNet-Hosting.com - Super low $4.75/month.
Single all inclusive features plan with MS SQL Server, MySQL 5, ASP.NET,
PHP 5 & webmail support.http://vyaskn.tripod.com/search_all..._all_tables.htm

HTH, Jens Suessmeyer

No comments:

Post a Comment