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