How to search an entire MS SQL 2005 DB for a value?

Question

How can I search an entire MS SQL 2005 DB for a value? For example 'ABC12345'.

Thanks.

Answer 1

You query INFORMATION_SCHEMA.TABLES for all the tables then query each table.

See http://stackoverflow.com/questions/593746/sql-to-search-the-entire-ms-sql-2000-database-for-a-value for details.

JR

Answer 2

Also discussed here: http://stackoverflow.com/questions/591853/search-for-a-string-in-an-all-the-tables-rows-and-columns-of-a-db

http://stackoverflow.com/questions/591853/search-for-a-string-in-an-all-the-tables-rows-and-columns-of-a-db/1077129#1077129 gives an easy solution which is to use http://www.ssmstoolspack.com/ (see http://www.ssmstoolspack.com/images/SDD.png).