SQL Server Management Studio
Applies To: SQL Server 2016 Preview
SQL Server Management Studio is an integrated environment for managing your SQL Server infrastructure. Management Studio provides tools to configure, monitor, and administer instances of SQL Server. It also provides tools to deploy, monitor, and upgrade the data-tier components, such as databases and data warehouses used by your applications, and to build queries and scripts.
To get the latest version, see Download SQL Server Management Studio.
SQL Server Management Studio is a comprehensive utility for managing SQL Server objects that combines an easy-to-use graphical interface with rich scripting capabilities. Management Studio can be used to manage Database Engine, Analysis Services, Integration Services, and Reporting Services.
Describes common tasks performed by using Management Studio, such as customizing keyboard shortcuts and viewing property pages.
Describes using Object Explorer to view and manage all of the objects in one or more instances of SQL Server.
Describes how to use Template Explorer to build and manage files of boilerplate text that can be used to speed the development of queries and scripts.
Describes how to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries.
Describes how to connect Management Studio to instances of the Database Engine and Analysis Services.
Describes how to use the visual design tools included in Management Studio.
Describes how to use the Management Studio language editors to interactively build and debug queries and scripts.