CTRL+R does not hide the Query Result window in SSMS

Question

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?

score 137 · Accepted Answer · answered Jun 13 '13 at 04:11

137

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.

answered Jun 13 '13 at 04:11

Charles Gagnon

3,619
2
17
7

4

This 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. – RLH Jun 13 '13 at 11:31
@Charles : Yes, It worked for me. Thanks Up Vote for you !! :) – Gaurav123 Feb 27 '14 at 06:48
3

This worked for me, too. But I did need to restart SSMS. – gligoran Mar 19 '15 at 11:03
2

Worked for me in SSMS2014 – Royi Namir Jan 05 '17 at 07:33
This 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). – Nyra May 13 '20 at 13:37

score 9 · Answer 2 · answered Mar 08 '16 at 07:21

9

This is missing in SSMS 2016 as well, assign it manually as shown below.

answered Mar 08 '16 at 07:21

Halim

2,090
2
16
9

ALT+R sounds good while setting the new shortcut, and instead of using **Global** option, **SQL Query Editor** sounds sensible. – ashubuntu Feb 25 '19 at 05:59

score 3 · Answer 3 · edited Jul 29 '17 at 06:06

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.

edited Jul 29 '17 at 06:06

Nathan Tuggy

2,237
27
30
38

answered Jul 29 '17 at 05:30

Pranav Kulshrestha

149
1
6

score 2 · Answer 4 · answered Apr 15 '16 at 04:09

2

If the previous answers does not help,

Use Ctrl+ ALT+ Shift + R this is already set in SSMS 2012.

This one worked for me..

answered Apr 15 '16 at 04:09

MarmiK

5,639
6
40
49

score 2 · Answer 5 · edited Dec 15 '19 at 16:10

2

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.

edited Dec 15 '19 at 16:10

Roberto Caboni

7,252
10
25
39

answered Dec 15 '19 at 10:22

Shawky

36
4

2

Though 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. – RLH Dec 15 '19 at 23:43

score 1 · Answer 6 · answered Jan 08 '15 at 12:33

1

Right-click the Toolbar -> Customize -> Commands -> Reset All -> (I recommend re-start of SSMS) This worked for me in ms sql 2012

answered Jan 08 '15 at 12:33

vivek

11
1

Artfaith · Answer 7 · 2021-08-11T22:32:29.130

In Microsoft SQL Server Management Studio v18.2 (aka. SSMS 18) you might want to try resetting keyboard mapping scheme in Options -> Environment -> Keyboard -> Keyboard window by clicking Reset button at the top of it with (Default) selected in option list.

Before resetting, it had only one option which processed Ctrl+R press only in DMX Query Editor:

After resetting it showed more options which included SQL Query Editor:

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

score 1 · Answer 8 · answered Sep 20 '19 at 06:51

1

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

answered Sep 20 '19 at 06:51

Nilesh Umaretiya

776
6
5

score 0 · Answer 9 · edited Sep 16 '17 at 20:28

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:

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 re-assign the shortcut to these values, or you can use native SSMS2012 keyboard shortcut editor.

CTRL+R does not hide the Query Result window in SSMS

9 Answers9

Linked