You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode under the query menu. You can easily add a keyboard shortcut to any menu item that you desire. Just right-click on the toolbar, and select customize. Then select Keyboard:
Search for the menu item that you want to assign a keyboard shortcut to (for instance, SQLCMD). Select the item, and then click in the “Press shortcut keys” box. Press the keyboard shortcut that you want to use. The “Shortcut currently used by” dropdown combobox will show anyplace that this keyboard shortcut is currently being used. When you have determined what keyboard shortcut that you want to use, just click the “Assign” button.
Open the Query menu to show that this shortcut is now connected to the SQLCMD Mode menu item:
This post is for day sixteen of my month-long blog series “A Month of SSMS Tips”. I have a landing page for the series at bit.ly/MonthOfSSMS. Please visit this page for an easy place to quickly view all of the other tips in this series.