Multi Query

• Run ad-hoc queries to make quick changes on multiple instances and databases
• Run existing queries to perform routine tasks or schema maintenance
• Use queries to compare data points from multiple instances and databases
• Create and reuse target lists of the instances and databases a query should act on
• Save the returned result sets to track statistics or object properties over time

1. On the Query Targets task bar, click Add.
2. Select the SQL Server instances and databases you want to include in this list:
   1. Specify the SQL Server instance or server group that contains the logins whose passwords you want to check, or click the browse button to select them. To specify multiple SQL Servers or server groups, separate each instance name with a semicolon.
   2. If you specified individual instances, select the authentication type you want Multi Query to use to connect to these instances.
   3. Indicate whether you want Multi Query to act on the default database (as defined in SQL Server) or a specific database.
   4. Click OK.
3. On the Query Targets task bar, click Save. Consider specifying a name that correlates with the queries you intend to run against this list of targets.

1. In Query Targets pane, specify which instances and databases that you want the query to target. You can:
   • Specify new targets by clicking Add.
   • Use an existing list of targets by clicking Open, and then customize the list by adding, editing, or removing targets.
2. In the Query text pane, enter the query you want to run. You can:
   • Type an ad-hoc query in the provided text pane.
   • Run an existing script by clicking Open to select the script file.
3. Run your query. You can:
   • Run your query against all listed targets by clicking Execute Query.
   • Run your query against specific targets by clicking 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.

Use the Query Options to narrow the scope of the returned result set and improve performance when running queries that:

• Return more results than you expected
• Are being run against many different targets
• Have complex functions

By default, Multi Query connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then runs the specified query against those instances.

If you do not specify a database, Multi Query will connect to the default database (configured in SQL Server) and run the query on that database.