SQL Management Studio 2012 (SSMS) Keyboard Shortcuts

So I’ve installed SQL Server 2012 on my Windows 7 machine and have encountered an unexpected issue that drove me absolute bonkers. I make extensive use of keyboard shortcuts for comments code, showing/hiding results panes, auto formatting code, etc… In the new SQL Management Studio much to my surprise, the good old fashion CRTL+R shortcut to toggle the results pane did not work. My first instinct was to try different combinations of shortcuts like CRTL+R+R or CRTL+D+R etc… Nothing worked. So I did some googling and found the following MS article http://msdn.microsoft.com/en-us/library/ms174205.aspx which states that the Ctrl+R shortcut is suppose to work.

Luckly, after some more searching I stumbled upon this MSDN blog http://blogs.msdn.com/b/managingsql/archive/2011/07/13/enhanced-keyboard-shortcuts-in-ssms-in-denali.aspx which helped me figure out how to fix it. What I learned is that SSMS 2012 ships with two different keyboard schemes “Default” and “Visual Studio 2010 Compatible”. Even though mine was set to Default, my Ctrl+R shortcut still didn’t work. So let me cut to the chase, here’s how you fix it:

1.    Open SSMS 2012

2.    Click menu Tools > Options

3.    Expand Environment > Keyboard

4.    Select “Default” if it isn’t already and click the Reset button

5.    Click the OK button

 

At this point, you can test your shortcut and you will find that it now works as expected.

 

Leave a Reply