Adding a new keyboard shortcut in SSMS.

,

I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won’t use the mouse, but only when I have to. One frequent (and annoying) task that I haven’t been able to find a keyboard shortcut for is opening the Change Connection window.

UserFunction

Recently I’ve been working on configuring my SSMS (Management Studio). I’ve used Aaron Bertrand’s (b/t) query window color format and modified my new query template. So while I was at it, I finally decided that since I couldn’t find a short cut to open the Change Connection window, I’d go ahead and create one.

How you may ask?

Well it’s pretty simple. First go to Tools->Customize and hit the Keyboard button.

UserFunction2

Next perform the following steps:

  1. Select the right command to set the shortcut on.
    1. Type Query. in Show commands containing to just display the query commands.
    2. Select Query.ChangeConnection
  2. Change the Use new shortcut in to SQL Query Editor
  3. Click on Press shortcut keys: and hit the key combination you want to use. I’m using CTRL-F8 since it’s free.

    You can see the existing shortcut just below in Shortcut currently used by: if there is one.

  4. Hit the Assign button.
  5. Hit the Ok button (Unless you want to assign more shortcuts. If you do, go ahead, I’ll wait.)

 

UserFunction4

And the shortcut is now not only assigned but shows up in the menus as a reminder

UserFunction5

Filed under: Microsoft SQL Server, Settings, SQLServerPedia Syndication, SSMS Tagged: Adam Machanic, keyboard settings, microsoft sql server, SSMS

Rate

Share

Share

Rate