Making SSMS Work for You

I love taking advantage of the customizable keyboard shortcuts in SSMS. You can put in stored procedures to be run when you press certain key combinations. For example, I have sp_helptext run when I press CTRL+5 and an expanded version of sp_who2 when I press CTRL+3. This way, when I highlight an object, I can simply press CTRL+5 to see the text. You can get to to the Options window in SSMS by clicking on Tools / Options / Keyboard. ALT+1 by default is sp_help.

This entry was posted in Configuration, DBA. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *