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.