SQL Server Management Studio Keyboard Shortcuts

On a daily basis we used to similar work, like, health check, stored procedure, objects detail, error log and many of them.

In SSSM we can use these queries with shortcut. I use below shortcut for same

Alt + F1: sp_help

Ctrl + F1: sp_helptext
Ctrl + 1: Sp_who
Ctrl + 2: sp_lock
Ctrl + 3: sp_who2 Active
Ctrl + 4: xp_readerrorlog

So now how to do this

1. Open SSMS -->Tools --> Options --> Keyboard 

 

2. Once we saved your queries with shortcut, Close SSMS and open new window query. Now Shortcuts are ready to use.
 
3. Please always use select queries (which don't do any insert/update operation).