Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 editor. To complete these procedures, you must have an active Transact-SQL editor session that is connected to a database.
To disconnect from a database in the Transact-SQL editor
On the Data menu, point to Transact-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 Transact-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 Transact-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