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.
sql-server-2012ssms
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.
Best Answer
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.