Shortkut keys do not work in my SSMS

Question

Shortkut keys do not work in my SSMS

SQL Guy 1

SSCoach

Points: 15979
More actions
April 11, 2017 at 1:29 pm

#322874

I recently moved from SSMS 2008 to 2014 version 12.0.2000.8.
And I found that some shortcut keys don't work here:
F8 - to display object explorer
Ctrl+L - execution plan
Ctrl+R - to switch between code and result windows
Did I miss something in my setups? Or there are new keys in 2014 instead?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Bill Talada SSChampion Points: 11954 More actions · Answer 1

Yes, some hotkeys and features were removed from the display. I actually like having the "Show Results Pane" on the toolbar better than the old ctrl+r hotkey. Add it with the following dialog in ss2014:

And for your other two requests:
Alt, v, j will bring up the object explorer
Alt, q, p will bring up the query plan

I had to go into the toolbar customizer window to see the hotkeys to use.

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 2

Thank you, Bill.

Finally I could add Show Results Pane to buttons bar. I used to always work with keyboard, with minimal touching a mouse, I think this way is more productive for us database professionals. And maybe I am too conservative, but it looks that with every new version they (SQL Server development team) makes it harder for us to use the tools.

And by the way, is there any customization where I can assign shortcut keys to any command? That I think would be helpful, too.

Bill Talada SSChampion Points: 11954 More actions · Answer 3

Yes you can assign the old hotkeys to your functions but you may need to un-assign the hotkeys from new functions first:

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 4

Thank you again, Bill, but even after I removed all 4 shortcuts from selected command, I can't type anything in "Press shortcut keys:" text-box.

Bill Talada SSChampion Points: 11954 More actions · Answer 5

It is not really a typing area; it captures the actual hotkeys you press. First I cleared all the ctrl+r existing hotkey mappings. Then, I assigned the hotkey to the "show results pane" and it worked for me on my second try.