MS SQL Server

Search a String or Word From All the Tables in a SQL Server Database

Job History


This procedure is to search a string or word from the entire database tables in a given database. Suppose if anyone does not know where exactly the specific string, then this will be your friend. This is tested in SQL 2000.

The technical experts should bear in mind that it may disturb the existing live performance. It is always advisable to take a copy of the database and restore it in different name and search.



Leave a Reply

Your email address will not be published. Required fields are marked *