After clicking the Next button, you can specify even more options.  This screen allows you to specify one or more databases to search against.  The search I ran was for authors.  I don't know what server or in which database any reference to authors resides, so I am searching across multiple servers and multiple databases for any occurrence of that string.

The search results are shown below.  The left hand pane gives you a datasource listing so that it is easy to determine where the occurrences of your search string were found.  It further explodes to show each of the objects that string was found in.   Highlighting an object will cause a number in parenthesis to appear after the name.   This number indicates the number of occurrences of the search string that were found.  The right hand pane shows you the object syntax with the search string set off from the rest of the text for easy location.  Selecting the Open button will open the object in an editor so that you can make modifications.  Clicking the Extract button will extract the DDL required to recreate the object.  The only improvement that could be made to this is to add in a replace feature so that you can perform an actual search and replace across your databases.  Although, I'm not entirely certain I would want to do something like that.  I can't tell you how many times I have used the search feature, but it has saved me 100s of hours of work in digging through systems.

DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21