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.