Ctrl R not working in SQL Server 2012

sql-server-2012 ssms
Yajuvendra Vant picture Yajuvendra Vant · Feb 3, 2014 · Viewed 65.5k times · Source

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

Answer

Aaron Bertrand picture Aaron Bertrand · Feb 3, 2014

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.

Related questions

Where is SQL Server Management Studio 2012?

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop. I've installed SQL Server 2012 and have finally got SQL Server Data Tools to show up, so that I can create SSRS reports in Visual Studio 2010. Although I've installed …

Read More
Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
SQL Server Management Studio 2012 hangs

When I click on the "Databases" node in "Object Explorer" it just keeps on "Loading items" until at some point it just hangs. This happens only when connecting to a remote server, not when accessing a database on my PC. …

Read More