CTRL+R to Toggle the Results Pane Not Working Properly in SQL Server Management Studio (SSMS)
It is common for SQL Server DBAs to use SQL Server Management Studio (SSMS) for managing and administering SQL Server instances. SSMS offers variety of shortcuts to enable quick access to certain functions, one of such is the use of CTRL + R which can be used to Hide the results window or to show the results pane.
Recently, While I was using SQL Server 2014 Management Studio (SSMS) and when I tried to use the CTRL + R button, the results window was not getting cleared or not getting disappeared which ideally should. At the bottom left corner, I noticed a message that says “CTRL+R) was pressed. Waiting for second key of chord…”
The message displayed does not make any sense. After quick search, I found that this option can also be enabled from Menu options in SSMS. So, I clicked on “Window” menu option, but did not find the “Hide Results Pane” or the “Show Results Pane” options. After further research, found KB article which explains this issue to be caused because the .vssettings file for SQL Server Management Studio is corrupted.
However, this article says this is applicable for SQL Server 2012, but the issue happened for SQL Server 2014 SSMS. I went ahead and tried the below work around suggested in the above mentioned article and after which (CTRL + R) started working fine.
– Opened the SQL Server 2014 Management Studio.
– From the menu bar, clicked on “Tools”, and then clicked on Options.
– In the tree-view pane on the left side of the dialog box, clicked Keyboard.
– Clicked on “Reset” to reset the default keyboard mapping scheme.
– Next, In the dialog box that appeared, clicked on “Yes” and finally clicked on OK.
– Restarted SSMS and then I was able to use (CTRL + R) to toggle Results pane without any issues.
Use and Importance of SQL Server Management Studio
SQL Server Management Studio (SSMS) is used by DBAs and Developers for accessing, configuring, managing, development, and administering of SQL Server instances. SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities. SSMS combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels.
This is applicable on below versions of SQL Server
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.