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. 


28 comments:

  1. EstebanJanuary 26, 2012 at 9:26 PM

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

    ReplyDelete
  2. AnonymousFebruary 17, 2012 at 4:48 AM

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

    ReplyDelete
  3. PortmanteurApril 18, 2012 at 8:56 PM

    Sandesh is my hero.

    ReplyDelete
  4. AnonymousMay 4, 2012 at 8:37 PM

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

    ReplyDelete
  5. AnonymousMay 31, 2012 at 1:05 AM

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

    ReplyDelete
  6. AnonymousJune 6, 2012 at 3:48 AM

    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!! :-)

    ReplyDelete
  7. AnonymousJune 15, 2012 at 8:13 PM

    Worked. Thanks!!! Was driving me crazy.

    ReplyDelete
  8. HarshaJuly 9, 2012 at 4:35 PM

    thansk a lot...

    ReplyDelete
  9. AnonymousAugust 1, 2012 at 3:05 AM

    Bravo!

    ReplyDelete
  10. AnonymousAugust 2, 2012 at 7:31 PM

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

    ReplyDelete
  11. AnonymousAugust 7, 2012 at 8:16 PM

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

    ReplyDelete
  12. AnonymousAugust 14, 2012 at 8:06 PM

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

    ReplyDelete
  13. AnonymousAugust 15, 2012 at 4:03 AM

    Thankyou so much.. you made my life easy

    ReplyDelete
  14. AnonymousSeptember 20, 2012 at 11:05 PM

    thanks, great tip

    ReplyDelete
  15. AnonymousOctober 30, 2012 at 7:18 PM

    Excellent, just what I was looking for !

    ReplyDelete
  16. AnonymousJanuary 14, 2013 at 9:02 PM

    Thank you Very Much!!

    ReplyDelete
  17. AnonymousJanuary 22, 2013 at 10:08 PM

    Thank you for this easy and usefull solution. William.

    ReplyDelete
  18. AnonymousFebruary 15, 2013 at 1:34 AM

    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.

    ReplyDelete
  19. AnonymousFebruary 19, 2013 at 1:22 PM

    Thanks a lot! :)

    ReplyDelete
  20. afsawafFebruary 19, 2013 at 9:01 PM

    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.

    ReplyDelete
  21. AnonymousFebruary 20, 2013 at 1:15 AM

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

    ReplyDelete
  22. AnonymousMay 30, 2013 at 8:09 PM

    Excellent, Thanks a lot!!!

    ReplyDelete
  23. Espen RudrudJune 10, 2013 at 12:57 PM

    Finally! Thank you very much :D!

    ReplyDelete
  24. AnonymousSeptember 11, 2013 at 6:20 PM

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

    ReplyDelete
  25. UnknownApril 14, 2016 at 3:42 AM

    Thanks a lot BUD!!!

    ReplyDelete
  26. indomakmurApril 30, 2020 at 5:02 PM

    Good web site! I truly love how it is simple on my eyes and the data are well written. I am wondering how I might be notified when a new post has been made. I have subscribed to your feed which must do the trick! Have a great day!Cheap Web Hosting Providers https://royalcbd.com/how-to-make-cbd-gummies-at-home/

    ReplyDelete
  27. 3dsiumApril 12, 2021 at 12:25 PM

    As a Newbie, I am permanently searching online for articles that can benefit me. Thank you 3dsium

    ReplyDelete
  28. HuongkvSeptember 6, 2021 at 8:20 AM

    Mua vé máy bay tại Aivivu, tham khảo

    vé máy bay đi Mỹ bao nhiêu

    mua vé máy bay về vn từ mỹ

    chuyến bay từ đức về hà nội hôm nay

    vé máy bay nga về việt nam

    giá vé máy bay từ anh về việt nam

    chuyến bay từ Pairs về TpHCM

    khách sạn cách ly

    vé máy bay chuyên gia sang Việt Nam

    ReplyDelete