Ctrl R not working in SQL Server 2012
sql-server-2012, ssms
Solution
Go to Tools > Options > Environment > Keyboard / General.
In the middle box,
- Select `Window.ShowResultsPane`
- Change the `Use new shortcut` dropdown to `SQL 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.
Problem
In SQL Server 2012, Ctrl+R not working. Any other shortcuts for that. Any setting changes available or is there any alternative?