F5 stopped working in SSMS

Question

I am using SQLServer 2008 R2 Management Studio (10.50.2500.0) on Windows 7.

Suddenly the keyboard shortcut for execute query stopped working. The CTRL-E command still works but it's really anoying since I'm so used to F5. In the query menu the F5 command is replaced by CTRL+E.

My keyboard does not have an F-key lock button and the other F-keys are working. I have even tried using the on-screen keyboard so it's not related to my keyboard.

I think the problems started after an system update from Microsoft Update. How can i change it back? Cant find any options for remapping keys in SSMS.

Answer 1

I had similar issue and realized it was "F Lock" key issue. Make sure your F Lock key is on.

Answer 2

Try this solution: Goto folder:

C:\Users\USERNAME\Documents\SQL Server Management Studio\Settings You will see there file named like:

CurrentSettings-2011-11-28.vssettings

Find and erase there following line:

<RemoveShortcut Command="Query.Execute" Scope="SQL Query Editor">F5</RemoveShortcut>

EDIT: Don forget to restart ssms after doing the above changes