Ctrl R not working in SQL Server 2012

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.

Leave a Comment