Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Manage Connections > Switch Connections

Switch Connections

If you have multiple connections open, you can easily switch connections using the open connections drop-down list located in the Connections toolbar. All of your currently open connections are listed.

The Connections toolbar displays the currently active connection.
The open connections drop-down list displays all your open connections.
The open connections drop-down list also lists the open document associated with the connection (in the Document column).
If there are multiple documents associated with a connection, the documents are listed under the connection's node. Expand the node to display the list.
If you open a new document, Toad opens the document window and automatically applies the currently active connection (the one displayed in the Connections toolbar) to it.

To switch to a different connection

To switch to another open connection, and thereby making that connection the active one, do one of the following:

Select the connection from the open connections drop-down list in the Connections toolbar.
Double-click a connection in the Connection Manager.

To change the connection for an open document

To change the connection for a single open document, with the document window selected do one of the following:

Note: This is not the same as switching the active connection for your Toad session, as described above.

Right-click the document/window tab, select Change Connection, and then select another connection.
Select another connection from the drop-down list located in the Status bar at the bottom of the Toad window.

Tips:

The currently active connection always displays in the Connections toolbar.
Mouse over the name of the currently active connection in the Connections toolbar to display a descriptive tool tip containing information about the connection.
Mouse over each connection in the drop-down list to display a descriptive tool tip for that connection.
Expand a connection's node in the open connections list to display all open documents associated with that connection.
To view document windows that pertain to the current connection only, select the Only show tabs for documents of the current connection checkbox in Tools | Options | Environment | Interface.