Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Managing Database Connections within the Transact-SQL Editor

You can use the Transact-SQL (T-SQL) editor whether you are connected to a database or not. You can connect to only one database at a time, but you can connect to a different database, even one on a different server, without losing the contents of your editor session.

In This Section

How to: Connect to Different Databases in the Same Editor Session

Describes how you can switch from one database to another without starting a new editor session.

Considerations for Offline Editing

Provides an overview of what you can and cannot do in the T-SQL editor while you are not connected to a database.

How to: Disconnect from Databases

Describes how you can disconnect from the current database and work offline.

How to: Connect to a Database in the T-SQL Editor

Describes how you establish a connection to a server and database in the T-SQL editor.

Related Sections

Transact-SQL Editing Essentials

Contains topics that describe the most important editing tasks that you can perform by using the T-SQL editor.

Script Analysis and Execution in the Transact-SQL Editor

Contains topics that help you analyze and run your scripts and queries in the T-SQL editor.

Working with Database Objects

Provides an overview and links to topics that describe how you create, modify, and validate changes to database objects such as tables, stored procedures, and functions.

© 2015 Microsoft