CTRL + R does not hide query result window in SSMS

Question

I just upgraded from SSMS from 2005 to 2012. Previously, I could press CTRL + R , and the query result windows disappeared.

After I upgraded to SSMS, I fulfilled the request and out of habit hit CTRL + R. Nothing has happened. At the bottom of SSMS, I noticed that the message "(Ctrl + R). Waiting for the second key of the chord ..."

After you found out the details of this keyboard shortcut in the MSDN documentation , I found that CTRL + R should have hidden the window that appeared, as I suspected. However, my SSMS does not behave as documented.

Is there a way to restore this key combination to hide the query result window?

Answer 1

• Open the Tools menu, select Options ...
• In a node environment, click Keyboard node
• Click Reset
• Click Yes in the dialog box that appears.

This should solve your problem. If not, add a comment on this topic with detailed information about your problem.

Answer 2

It is also missing in SSMS 2016, assign it manually as shown below.

Answer 3

In my case, in the "Keyboard Settings" section, I searched for Window.ResultsPane . My default keyboard shortcut was Ctrl + R , and doing Ctrl + R didn't work for me. I set it to Ctrl + R , Ctrl + R , and now it works fine for me. Performing a reset is not a good idea, as it will delete all user preferences set by the user.

Answer 4

Right click Toolbar → Configure → Commands → Reset All → (I recommend restarting SSMS) This worked for me in ms sql 2012

Answer 5

If the previous answers do not help,

Use Ctrl + ALT + Shift + R , it is already installed in SSMS 2012.

This worked for me ..

Answer 6

I tested it on my SSMS2012 and it works, but I have a clean install. The reason may be an update since 2005. You can try changing the shortcut / toolbar settings to

Right-click Toolbar → Configure → Commands → Reset All → (I recommend restarting SSMS)

If this does not help, try to assign the command "Window.ShowResultsPane" to the Ctrl + R command. I am developing an add-on for SSMS - SSMSBoost , it has many good features, and one of the smallest - resets all registered commands using their shortcuts. So, on my machine, I found that Ctrl + R is registered in the following contexts for the same command:

 SQL Query Editor::Ctrl+R Window.ShowResultsPane MDX Query Editor::Ctrl+R Window.ShowResultsPane DMX Query Editor::Ctrl+R Window.ShowResultsPane XMLA Query Editor::Ctrl+R Window.ShowResultsPane 

SSMSBoost will also allow you to reassign a shortcut to these values, or you can use the SSMS2012 native keyboard shortcut editor.

Answer 7

In Microsoft SQL Server Management Studio v18.2 (aka. SSMS 18) you can try resetting the keyboard mapping scheme in the Options -> Environment -> Keyboard -> Keyboard window by clicking the Reset button at the top, selecting (Default) in the list of options.

Prior to the reset, he had only one option, which handles Ctrl + R pressing only in the DMX Query Editor :

After the reset, more options were shown, including SQL Query Editor :

After that, the keyboard shortcut works (Windows 10 1809 x64).

Answer 8

Go to Tools> Options> Environment> Keyboard / General.