Page History

...

To search for specific text using the SQL Search tool:

1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click SQL Search.
2. Search for and then select the SQL Server instance whose schema you want to search.
3. Search for and then select the database on this instance you want to search. To specify multiple databases, separate each database name with a semicolon. Leave this field empty if you want to search all user databases.
4. Type the word or phrase you want to find. To search for text variations using SQL wildcards, append or prefix the word with an underscore character. For example, "lab" or "lab".
5. Optional. Check the options you want to use in this SQL text search.
6. Click Perform Search.
7. If you want to see the SQL source, select the SQL excerpt, and then click View Source.
8. If you want to save the results, click Copy Results To Clipboard, or right-click to save the results as an XML or CSV file.

...

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...