Introduction
The key combination of "CTRL+R" is used to show or hide the query results pane. Sometimes we do not require a query results pane and therefore it can be hidden using the keyboard shortcut keys "CTRL+R". However, there is no direct option to hide this pane.
Problem statement
Recently, I had installed a fresh copy of SQL Server 2012 Express Edition with advanced services in my machine. Then, I loaded SQL Server Management Studio and executed a sample query. Let us say that after analyzing the query results, I wanted changes in my query and did not require the query result. Generally, in this case we will use the keyboard combination CTRL+R to hide the results pane. But, here the result pane was visible even after pressing the key CTRL+R.
Solutions
Solution: 1
The following is the procedure to get the shortcuts working again.
- Go to the Tools Menu in SSMS and Select Options.
- Select Keyboard section under the Environment tab.
- Select "Default" from the drop down under "Apply the following additional keyboard mapping scheme".
- Click Reset.
Solution: 2
We can also assign our custom shortcut keys. Here's another way to get the shortcut working again.
- Go to the Tools Menu in SSMS and Select Options.
- Select the Keyboard section under the Environments tab.
- Search for the text “Window.ShowResultsPane” using the “Show commands containing” TextBox.
- Select the “SQL Query Editor” option from the dropdown under “Use new shortcut in” and type CTRL+R in “Press shortcut keys” TextBox. Now, click assign.
I hope this helps!