Hi,

I'm using sql 2005 and 2008 and trying to find the text in all tables of all
databases.
Is there a script that I can use?

Thanks a lot,
Sarah

Here is a script to search in all tables in one database:
http://vyaskn.tripod.com/search_all_...all_tables.htm

You can use the undocumented sp_MSForEachDB to iterate over all databases:
http://www.kodyaz.com/articles/sql-s...tsql-code.aspx

--
Plamen Ratchev
http://www.SQLStudio.com