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.
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.
Go to Tools > Options > Environment > Keyboard / General.
In the middle box,
- Select
Window.ShowResultsPane
- Change the
Use new shortcut
dropdown toSQL Query Editor
(Global did not work for me) - Put your cursor in the "Press shortcut keys:" box and hit CTRL + R. You should see the following:
- 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.