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 Transact-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.

• Scenario: Create and Modify Database and Server 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.