Posted by Tony on 09/14/05 02:38

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.

• Next in forum: Script to search for a string in all varchar columns in all tables in a database?
• Prev in forum: Script to search for a string in all varchar columns in all tables in a database?
• Thread view: Script to search for a string in all varchar columns in all tables in a database?

[Reply to this message]