Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

When I go to Tools > Options > Environment > Keyboard. Type in Query.Sp_whoisactive Press shortcut keys: Ctrl+F1 Click Assign.

When I press Ctrl+F1, It still calls Help.

share|improve this question
Does that stored procedure actually exist in your instance? That is not an ms-shipped SP. Can you run it manually? – Thomas Stringer Apr 6 '12 at 16:19
Also did you try EXEC master..sp_whoisactive (assuming you created it in master)? – Aaron Bertrand♦ Apr 6 '12 at 17:51
@AaronBertrand Isn't that unnecessary, as a prefix of sp_ causes SQL Server to look in the master database first anyways? – Thomas Stringer Apr 6 '12 at 18:03
The EXEC was more the key – Aaron Bertrand♦ Apr 7 '12 at 7:17
I had the same issue, I've logged it on Microsoft Connect – Paddy Apr 18 '12 at 10:59

2 Answers

up vote 3 down vote accepted

Click on Tools > Options. Then navigate to Environment > Keyboard > Query Shortcuts.

share|improve this answer
Ah, good catch. The OP probably didn't change it in the Query Shortcuts part, but the main Keyboard section. – Thomas Stringer Apr 6 '12 at 18:19
I still can't assign Ctrl+F1 combination. But Ctrl+3 works – ob213 Apr 6 '12 at 19:14
up vote 0 down vote

In Sql Server 2012, control + F1 is assigned to View Help (Check the Help menu in SSMS). I don't think now we can re-assign to some other functionality. But still I'm not sure why the Control+F1 option is provided in Query Short cuts. So there may be a provision to re-assign this also. Not sure, we have to explore the new features in Sql Server 2012.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.