Page History

...

To create a query target list using the Multi Query tool:

1. Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Multi Query.
2. On the Query Targets task bar, click Add.
3. Search for and then select the SQL Server instance or server group that you want to query. To specify multiple SQL Servers or server groups, separate each name with a semicolon.
4. Select the authentication type you want the Multi Query tool to use to connect to these instances.
5. Optional. Click Test Connection to verify that you can connect using the entered authentication specifics.
6. Indicate whether you want the Multi Query tool to act on the default database (as defined in SQL Server) or a specific database.
7. Click OK.
8. 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.

...

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

...