Title

Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.
Welcome to Kodyaz Development Resources Sign in | Join | Help




Create Short-Cuts in SQL Server Management Studio Query Window

Using short-cuts in SQL Server Management Studio query windows may ease your job while editing and writing sql codes and statements.
One of the short-cuts that is defined by default and very well-known is Alt+F1 key combination. Alt-F1 is the short-cut of "sp_help" system stored procedure.
Alt+F1 key combination runs the sp_help stored proc sp which can be used to view the table columns, constraints, indexes, etc. of the table that is highlighted.
I generally use the system stored procedure sp_helptext that I use to see the text of the stored procedure that is highlighted in the query window.
Since I use sp_helptext frequently, I defined Ctrl+F1 key combination as a short-cut for sp_helptext sp.
It is easy to define short-cuts for the query editor window. Just go to menu Tools then Options... to open the screen where you can set different sets of options for the Microsoft SQL Server Management Studio.

tools-options-environment-keyword-new-query-window
If you open the Keyboard options in the Environment directory, you can see all query shortcuts defined.
  • Alt+F1 is for sp_help
  • Ctrl+1 is for sp_who
  • Ctrl+2 is for sp_lock


  • And I defined the shortcut Ctrl+F1 for running the stored procedure sp_helptext.
    Do not forget to open a new query window in order to use the new shortcut.



    BlinkListBlinkList   Del.icio.usDel.icio.us   DiggDigg   FurlFurl   SimpySimpy   SpurlSpurl   DZoneDZone   ma.gnoliama.gnolia   ShadowsShadows  



    Copyright © 2004 - 2008 Eralper Yilmaz. All rights reserved.
    Powered by Community Server, by Telligent Systems