snippetMinor
How to assign CTRL+F1 to sp_whoisactive in ssms 2012?
Viewed 0 times
ssms2012sp_whoisactivectrlhowassign
Problem
When I go to Tools > Options > Environment > Keyboard and
Type in Query.Sp_whoisactive
Press shortcut keys: Ctrl+F1
Click Assign.
When I press Ctrl+F1, It still calls Help.
Type in Query.Sp_whoisactive
Press shortcut keys: Ctrl+F1
Click Assign.
When I press Ctrl+F1, It still calls Help.
Solution
Click on Tools > Options. Then navigate to Environment > Keyboard > Query Shortcuts. In the stored procedure column next to Ctrl+F1, type Sp_whoisactive.
Next navigate to Tools > Options > Environment > Keyboard > Keyboard, and find the command Query.CustomSP1. Assign the shortcut Ctrl+F1. Then search for the command Help.ViewHelp and remove the mapping for Ctrl+F1 there.
Next navigate to Tools > Options > Environment > Keyboard > Keyboard, and find the command Query.CustomSP1. Assign the shortcut Ctrl+F1. Then search for the command Help.ViewHelp and remove the mapping for Ctrl+F1 there.
Context
StackExchange Database Administrators Q#16182, answer score: 4
Revisions (0)
No revisions yet.