I'm looking for a way to connect to a database server with a user supplied username/password and then searching through all the databases for a particular text string.

I know I can connect to each database individually and type sp_findtext '%<word>%' but it would be much easier to do this programmatically.

I came across some code to do this a few years ago, but can't seem to find it now.

There's actually 3 steps to this:

1. Connecting to a database server with a user name and password
2. Getting a list of all the databases connected to the server
3. Connecting to each individual database and searching for particular text.

I primarily need an example for step 3.

Thanks

Do you know the structure of the database ? I mean, if you knew the tables and columns, you could write a usual query for the text columns in every database/table you're interested in.

Or is this to simple an answer ?

I was more looking for what was in the stored procedures. I wanted a way for it to easily connect to one database, do the search and return the results, then hit the next database and repeat the process for all databases.