Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Ctrl R not working in SQL Server 2012

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

like image 413
Yajuvendra Vant Avatar asked Feb 03 '14 14:02

Yajuvendra Vant


People also ask

Why Ctrl +r not working in SQL Server?

Go to the Tools Menu in SSMS and Select Options. Select Keyboard section under the Environment tab. Select "Default" from the drop down under "Apply the following additional keyboard mapping scheme". Click Reset.

How do I enable Ctrl in R?

How to use the Ctrl+R keyboard shortcut. To use this keyboard shortcut, press and hold either Ctrl key, and while continuing to hold, press R .


1 Answers

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.

like image 74
Aaron Bertrand Avatar answered Oct 04 '22 15:10

Aaron Bertrand