Ctrl R not working in SQL Server 2012

I'm using Microsoft SQL Server Management Studio version 11.0.3128.0 (SSMS 2012). Started having the above issue for no aparent reason. Solved like this: click "Tools -> Options". On the options window, open Environment -> Keyboard on the tree. Then, on the right, press the "Reset" button. Worked for me.


Another way is to select Default and hit the Reset button. This worked for me.

enter image description here


I am using Microsoft SQL Server Management Studio version 12.0.4100.1 (SSMS 2014). I had the same issue and resolved it by following below steps -

Click "Tools -> Options". On the Options window, expand Environment -> Keyboard -> Keyboard. Then, in the right side panel, press the "Reset" button.

See the screenshot below -


Go to Tools > Options > Environment > Keyboard / General.

In the middle box,

  1. Select Window.ShowResultsPane
  2. Change the Use new shortcut dropdown to SQL Query Editor (Global did not work for me)
  3. Put your cursor in the "Press shortcut keys:" box and hit CTRL + R. You should see the following:

enter image description here

  1. Click Assign and then OK.

Unlike some other changes that still require an SSMS restart to take effect, the change takes effect immediately, and CTRL + R should start working again.

I blogged about this three years ago.