| title | Use SQL Server Management Studio | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 06/13/2017 | |||
| ms.prod | sql-server-2014 | |||
| ms.reviewer | ||||
| ms.technology | ||||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | f289e978-14ca-46ef-9e61-e1fe5fd593be | |||
| author | mashamsft | |||
| ms.author | mathoma | |||
| manager | craigg |
[!INCLUDEssManStudioFull] (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of [!INCLUDEssNoVersion]. SSMS combines a broad group of graphical tools with a number of rich script editors to provide access to [!INCLUDEssNoVersion] to developers and administrators of all skill levels.
SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of [!INCLUDEssNoVersion], into a single environment. In addition, SSMS works with all components of [!INCLUDEssNoVersion] such as [!INCLUDEssRSnoversion] and [!INCLUDEssISnoversion]. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.
Download and install SSMS from the Microsoft Developer Network.
Features in SQL Server Management Studio
Lists the rich feature set included in [!INCLUDEssManStudioFull].
Tool Windows in SQL Server Management Studio
Describes the tools that are components of [!INCLUDEssManStudioFull].
Understand SQL Server Management Studio Windows Management
Describes how to manage the windows displayed in [!INCLUDEssManStudioFull].
Administer Servers with SQL Server Management Studio
Describes how to administer instances of [!INCLUDEssNoVersion].
Connect to Any SQL Server Component from SQL Server Management Studio
Describes how to connect to instances of [!INCLUDEssNoVersion] and how to perform certain tasks without a connection.
Object Explorer
Describes the features of the Object Explorer.
User Assistance in SQL Server Management Studio
Describes how to configure user assistance, such as Help, in [!INCLUDEssManStudioFull].
Query and Text Editors (SQL Server Management Studio)
Describes how to use the rich editing environment in [!INCLUDEssManStudioFull] to edit [!INCLUDEtsql], MDX, DMX and XML/A scripts.
Edit SQLCMD Scripts with Query Editor
Describes the capabilities and limitations of using Query Editor in SQLCMD mode.
Color Coding in Query Editors
Describes the meaning of the color coding in Code Editor windows.
SQL Server Management Studio Keyboard Shortcuts
Lists the keyboard shortcuts available in the [!INCLUDEssManStudioFull].
Customize Menus and Shortcut Keys
Describes how to create custom menus and shortcuts.
Solutions (SQL Server Management Studio)
Describes how to develop script projects and solutions.
Template Explorer
Describes how to use the [!INCLUDEssManStudioFull] templates and how to create custom templates.
Property Pages in SQL Server Management Studio
Describes the new property window layout in [!INCLUDEssManStudioFull].
Visual Database Tool Designers
Describes the Visual Database Tools that you can use to create queries, design or modify a database structure, or update data.