Ctrl R not working in SQL Server 2012

Question

In SQL Server 2012, Ctrl+R not working. Any other shortcuts for that. Any setting changes available or is there any alternative?

Answer 1

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:

4. 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.