Tuesday, March 17, 2015

Assign shortcut key to "change connection" in SSMS

1) Right click on the menu banner, and select "Customize"
2) Click on the "Commands" tab.
3) Click on the radio button next to "Toolbar", then scroll through the list to select "SQL Editor"

4) Now you can click on the "Change Connection" control, Once highlighted, click on "Modify 
5) Selection" over on the right, and set it to "Image and Text", and place the & symbol infront of whatever ALT-KEY you want.
6) I have chosen to place the & symbol in for the C, so my shortcut is ALT-C to get to the change connection option.