CTRL+R does not hide the Query Result window in SSMS
Solution 1
- 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.
Solution 2
This is missing in SSMS 2016 as well, assign it manually as shown below.
Solution 3
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.
Solution 4
If the previous answers does not help,
Use Ctrl+ ALT+ Shift + R this is already set in SSMS 2012.
This one worked for me..
Solution 5
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.
![RLH](https://i.stack.imgur.com/HfDJ2.png?s=256&g=1)
RLH
Updated on July 05, 2022Comments
-
RLH almost 2 years
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?
-
RLH about 11 yearsThis worked. The really odd thing is, I did a fresh install and not, techincally, a real upgrade. I don't recall the installer ever asking to import any settings and, if it did, my SSMS should have behaved as normal. Regardless, this has fixed my issue.
-
Gaurav123 over 10 years@Charles : Yes, It worked for me. Thanks Up Vote for you !! :)
-
gligoran over 9 yearsThis worked for me, too. But I did need to restart SSMS.
-
Royi Namir over 7 yearsWorked for me in SSMS2014
-
ashubuntu over 5 yearsALT+R sounds good while setting the new shortcut, and instead of using Global option, SQL Query Editor sounds sensible.
-
RLH over 4 yearsThough not quite the answer most people will need from my original question, I understand that this one may help others. I’ll give you an upvote to bump you up the list. Thanks for giving a secondary option. If others aren’t using this tool, maybe they are using others.
-
Nyra about 4 yearsThis too worked for me. First I checked that the shortcut was still mapped correctly, and it was, so I did this as a fix, and it started working. I had not updated anything, I had just executed a query (and had been using this shortcut while developing and viewing results vs query), and then it stopped working.. Is this a known bug? cannot find info on 'why' this is happening, but it happens sporadically to me. FWIW - it stopped working when my query threw an error, and it affected the entire SSMS instance (all query windows).