This is something that I wish I had discovered years ago. I have put together my nine most used queries, functions, or system stored procedures that I use most everyday.
The configuration of the keyboard query shortcuts are buried with in the SSMS. To get to the correct dialog box, click on the Tools drop down menu and then click on the Options menu item.
In the left panel, navigate under the Environment to the Keyboard and click on Query Shortcuts in the Options dialog box.
Displayed are the three defaults that can not be changed. Wish they could because I would replace sp_who with sp_who2.
My recommendations for DBAs (developers would want different queries, functions, or system stored procedures):
Alt+F1 sp_help (default) Ctrl+F1 sp_helpfile Ctrl+1 sp_who (default) Ctrl+2 sp_lock (default) Ctrl+3 sp_who2 Ctrl+4 select @@version Ctrl+5 select @@servername Ctrl+6 sp_spaceused Ctrl+7 dbcc sqlperf(logspace) Ctrl+8 xp_fixeddrives Ctrl+9 xp_readerrorlog 1 Ctrl+0 xp_readerrorlog
Below is what the Options dialog box looks like in my SSMS:
When using the keyboard query shortcuts, the shortcuts being used does not appear in the query window. The results return just the lower panel. The example pictured below is of the sp_who2 stored procedure results.
Using a stored procedure that can accept a parameter like sp_help. Highlight the parameter then click on the Alt + F1 keys to run the sp_help stored procedure.
Leave a Comment