How to: Disconnect from Databases
You might want to disconnect from a database for several reasons: to minimize the number of active connections to the server; because you want to keep working without access to a database connection; because you set a query option to disconnect after execution; or because you are switching connections between database servers. Even if you are disconnected from a database, you can still edit a script or a query in the Transact-SQL (T-SQL) editor. To complete these procedures, you must have an active T-SQL editor session that is connected to a database.
To disconnect from a database in the T-SQL editor
On the Data menu, point to T-SQL Editor, point to Connection, and click Disconnect.
The editor session disconnects from the database. The window title changes to read "QueryName.sql - Disconnected", and the property browser shows the connection status as "Disconnected".
To disconnect from a database using the shortcut menu
Right-click in the T-SQL editor, point to Connection, and click Disconnect.
The editor session disconnects from the database. The window title changes to read "QueryName.sql - Disconnected", and the property browser shows the connection status as "Disconnected".
To disconnect from a database using the toolbar
On the T-SQL Editor toolbar, click Disconnect.
The editor session disconnects from the database. The window title changes to read "QueryName.sql - Disconnected", and the property browser shows the connection status as "Disconnected".
See Also
Tasks
How to: Connect to Different Databases in the Same Editor Session