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
Join the conversation! Your thoughts help the community grow.