CODEWITHSUNDEEP
sql-server-2012ssms
Yajuvendra Vant
Yajuvendra Vant

Reputation: 1127

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?

Upvotes: 61

Views: 74262

Answers (6)

anon
anon

Reputation:

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.

Upvotes: 124

LonelyRogue
LonelyRogue

Reputation: 466

I am troubled with this after I installed Visual Studio 2015. When Ctrl+N is pressed in SSMS, instead of opening a query window, SSMS showed up selection page of the VS files. A Reset as posted above revert to SSMS shortcuts.

Thanks for the posts.

--In 'thoughts'...

Upvotes: 0

mithun_daa
mithun_daa

Reputation: 4384

Go to the Keyboard Settings as mentioned by @aaron and then change the keyboard mapping scheme (first drop down). This gave me back the shortcuts that I am used to like Ctrl+R and Ctrl+E

Upvotes: 1

Sandy
Sandy

Reputation: 760

I am using Microsoft SQL Server Management Studio version 12.0.4100.1 (SSMS 2014). I had the same issue and resolved it by following below steps -

Click "Tools -> Options". On the Options window, expand Environment -> Keyboard -> Keyboard. Then, in the right side panel, press the "Reset" button.

See the screenshot below -

Upvotes: 9

joe
joe

Reputation: 787

Another way is to select Default and hit the Reset button. This worked for me.

enter image description here

Upvotes: 54

Mukund Thakkar
Mukund Thakkar

Reputation: 1295

I'm using Microsoft SQL Server Management Studio version 11.0.3128.0 (SSMS 2012). Started having the above issue for no aparent reason. Solved like this: click "Tools -> Options". On the options window, open Environment -> Keyboard on the tree. Then, on the right, press the "Reset" button. Worked for me.

Upvotes: 18

Related Questions