CTRL+R does not hide the Query Result window in SSMS
I just upgraded from SSMS 2005 to 2012. Previously, I could hit CTRL+R and the Query Results windows would disappear.
After I upgraded to SSMS I ran a query and, out of habit, hit CTRL+R. Nothing happened. At the bottom of SSMS I noticed that the status bar was reporting "(Ctrl+R) was pressed. Waiting for the second key of chord..."
After checking out the details of this keyboard shortcut in the MSDN documentation, I found out that CTRL+R was suppose to hide the resulting window as I had suspected. However, my SSMS isn't behaving as documented.
Is there a way that I can restore this keyboard shortcut to hide my Query Result window?
- Open the Tools menu select Options...
- Under the Environment node click on the Keyboard node
- Click the Reset button
- Click Yes on the dialog that pops up
That should solve your issue. If not please add a comment to this thread with details about your issue.
This is missing in SSMS 2016 as well, assign it manually as shown below.
In my case, under Keyboard Settings, I searched for Window.ResultsPane. My default keyboard shortcut was Ctrl + R, and doing Ctrl + R was not working for me.
I have set it to Ctrl + R, Ctrl + R and now it's working fine for me. Doing a reset is not a good idea since it would be removing any and all custom settings set by the user.
If the previous answers does not help,
Use Ctrl+ ALT+ Shift + R this is already set in SSMS 2012.
This one worked for me..
I tried the solution marked as answer and it didn't work with me. I even tried to uninstall the SSMS and install it back. Nothing was fixed.
Finally I went to the uninstall a program in control panel to see what did I have recently installed, and Voila, "TinyTake" by MangoApps was holding the CTRL+R combination.
I killed the process and everything went back to normal. So finally I went to "Startup" in task manager and disabled it.