| title | Understand SQL Server Management Studio Windows Management | ||||
|---|---|---|---|---|---|
| ms.custom | seo-lt-2019 | ||||
| ms.date | 01/19/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | sql-tools | ||||
| ms.reviewer | |||||
| ms.technology | ssms | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | bebf8383-dcaf-466e-84f5-63b81c9cfe52 | ||||
| author | markingmyname | ||||
| ms.author | maghan |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] The tool windows in [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] are a highly functional, flexible, and efficient system that allows you to:
-
Maximize the user workspace for development and management.
-
Reduce the number of unused windows displayed at one time.
-
Easily customize the user environment.
Manipulating windows is central to the [!INCLUDEssManStudio] environment. Users can easily access the tools and windows they use frequently. Users can control how much space they want to allocate to different information, and the environment should maximize the space available for editing queries accordingly. Windows can be moved to different locations on the screen. Many windows can be undocked and dragged out of the [!INCLUDEssManStudio] frame. This is particularly useful when using more than one monitor.
To increase your editing space while maintaining functionality, all windows offer the Auto Hide feature, which displays the window as a tab within a bar along the border of the main [!INCLUDEssManStudio] environment. When the pointer is placed over one of these tabs, the underlying window reveals itself. Auto Hide for a window can be toggled by clicking the Auto Hide button, represented by a pushpin in the upper-right corner of the window. There is also an Auto Hide All option on the Window menu.
Some components can be configured in either tabbed mode where components appear as tabs in the same docking location, or in multiple document interface (MDI) mode where each document has its own window. To configure this feature, on the Tools menu, click Options, click Environment, and then click General.
Important
When a login (or a contained database user) connects and is authenticated, the connection stores identity information about the login. For a Windows Authentication login, this includes information about membership in Windows groups. The identity of the login remains authenticated as long as the connection is maintained. To force changes in the identity, such as a password reset or change in Windows group membership, the login must logoff from the authentication authority (Windows or [!INCLUDEssNoVersion]), and log in again. A member of the sysadmin fixed server role or any login with the ALTER ANY CONNECTION permission can use the KILL command to end a connection and force a login to reconnect. [!INCLUDEssManStudioFull] can reuse connection information when opening multiple connections to Object Explorer and Query Editor windows. Close all connections to force reconnection.
Important
When a login (or a contained database user) connects and is authenticated, the connection caches identity information about the login. For a Windows Authentication login, this includes information about membership in Windows groups. The identity of the login remains authenticated as long as the connection is maintained. To force changes in the identity, such as a password reset or change in Windows group membership, the login must logoff from the authentication authority (Windows or [!INCLUDEssNoVersion]), and log in again. A member of the sysadmin fixed server role or any login with the ALTER ANY CONNECTION permission can use the KILL command to end a connection and force a login to reconnect. [!INCLUDEssManStudioFull] can reuse connection information when opening multiple connections to Object Explorer and Query Editor windows. Close all connections to force reconnection.
Use SQL Server Management Studio
The SQL Server Management Studio Environment