Denali CTP 3 - Show\Hide Results Pane keyboard shortcut not working - Ctrl+R not working | SansSQL

Thursday, September 1, 2011

Denali CTP 3 - Show\Hide Results Pane keyboard shortcut not working - Ctrl+R not working

Recently I installed Denali CTP 3 version and was writing a code which is coming next in this blog. During that time I attempted to hide the results pane using the keyboard shortcut Ctrl+R and was surprised that the keyboard shortcut Ctrl+R was not working. When I investigated further I found that that the keyboard shortcut was not assigned to the command "Hide Results Pane".
To fix this issue or to assign the keyboard shortcut to the command "Hide Results Pane", follow the below steps.
  1. In a SSMS window, go to "Tools" menu and choose "Options".
  2. In the left pane of "Options" window, expand "Environment" and then click on "Keyboard".
  3. In the right pane, Search for the command "Window.ShowResultsPane" Under "Show Commands Containing:" section and select that command
  4. Now, Under "Shortcuts for selected command:" section choose "SQL Query Editor" from the dropdown list of "Use new shortcut in:" sub-section.
  5. In the "Press shortcut keys:" sub-section place the cursor and press the keys "Ctrl" followed by "R" 
  6. Click on "Assign" button and click "OK" to exit the "Options" menu and start using the keyboard shortcut "Ctrl+R" to Hide\Show Results Pane. 


25 comments:

Esteban said...

Thanks man! SSMS 2012 has the same problem witch i solved doing what you said.

Anonymous said...

Thank you very much! I can now also go ctrl+shortcut crazy!!

Portmanteur said...

Sandesh is my hero.

Anonymous said...

Thanks homie! Been trying to figure this out all week!

Anonymous said...

Thank you so much! Seems so easy once you show it, options! Thanks again for showing.

Anonymous said...

Thanks! I was going wrong by not setting "SQL Query Editor". It didn't work if I set it as a global shortcut. Thanks so much!! :-)

Anonymous said...

Worked. Thanks!!! Was driving me crazy.

Harsha said...

thansk a lot...

Anonymous said...

Bravo!

Anonymous said...

Why MS decided to change something that we have been using since SSMS 2005 is beyond me, thank's for helping me restore it.

Anonymous said...

Excelente, tenia dos semanas penando por esa característica.

Anonymous said...

You rock! Thanks. Was getting soooo tired of that missing functionality!!!!

Anonymous said...

Thankyou so much.. you made my life easy

richmintz said...

thanks, great tip

Anonymous said...

Excellent, just what I was looking for !

Anonymous said...

Thank you Very Much!!

Anonymous said...

Thank you for this easy and usefull solution. William.

Anonymous said...

As a comment to everyone else, I only had to click the Reset button on the top right of the options menu. I'm wondering if there was something with a Visual Studio install that changed the default keyboard mapping scheme.

Anonymous said...

Thanks a lot! :)

Ahmed El Sawaf said...

I am afraid that I am having this dimmed as well, I am not even allowed to enter a key combination in the text box.

Anonymous said...

Thanks a lot...Was really getting frustrated as it wasn't working.

Anonymous said...

Excellent, Thanks a lot!!!

Espen Rudrud said...

Finally! Thank you very much :D!

Anonymous said...

Thank you, rescued my day (and days to come).

Unknown said...

Thanks a lot BUD!!!

Post a Comment