Page History

...

1. In the Query Targets pane, specify which instances and databases that you want the query to target. You can specify new targets by clicking Add, or use an existing target by clicking Open, and then searching for and selecting the appropriate target.
2. In the Query pane, enter the query you want to run. You can type an ad-hoc query in the provided text pane, or run an existing script by clicking Open, and then searching for and selecting the appropriate script.
3. If you want to run your query against all the listed targets, click Execute Query. If you want to run your query against specific targets, click Execute Against Selected Query Targets.
4. View the query status and results sets. You can:
   • View the query status using the Summary tab.
   • Combine result sets that contain the same columns using the Combined Results tab.
   • View individual result sets for a specific target.
   • Maximize the pane by clicking Full Screen.
5. If you want to save the results, copy the list to clipboard, or export the list as an XML or CSV file.

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