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?
Right-click the Toolbar -> Customize -> Commands -> Reset All -> (I recommend re-start of SSMS) This worked for me in ms sql 2012
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.That should solve your issue. If not please add a comment to this thread with details about your issue.
I have checked it on my SSMS2012 and it works, but I have clean install. The reason might be the upgrade from 2005. You can try re-setting the shortcuts/toolbar settings by
Right-click the Toolbar -> Customize -> Commands -> Reset All -> (I recommend re-start of SSMS)
If it will not help try to assign Ctrl+R to "Window.ShowResultsPane" command. I develop an add-in for SSMS - SSMSBoost, it has lots of good features and one of small ones is dumping all registered Commands with their shortcuts. So, on my machine I found out Ctrl+R to be registered in following contexts to same command:
SSMSBoost will also allow you to re-assign the shortcut to these values, or you can use native SSMS2012 keyboard shortcut editor.
This is missing in SSMS 2016 as well, assign it manually as shown below.
If the previous answers does not help,
Use Ctrl+ ALT+ Shift + R this is already set in SSMS 2012.
This one worked for me..