Home > SQL 2012, SSC > Ctrl+R in SSMS 2012

Ctrl+R in SSMS 2012

After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like in early versions, and one of the most shortcut key that I had problem after my installation of the SQL Server 2012 in the SSMS has been well known shortcut Ctrl+R to remove the last results pane from the SSMS! Ok lets take a look few steps how to activate it in the new SSMS of the SQL Server 2012:

Select > Tools > Customize … click “Keyboard”

In the list window scroll down and find to select “Window.ShowResultsPane”
Go to “Use new shortcut in:” – select “SQL Query Editor”
Go to “Press shortcut keys” text box and press Ctrl+R
Click “Assign” and finally OK!

Now, when you execute a select statement in SSMS and you have results set, you can remove them, pressing Ctrl+R, that is very often used from the Developers and DBA to clear the results pane!

This is very little help and enjoy it!

Stay Tuned…!

  1. 27/05/2013 at 07:09

    Thank you for sharing solution of this issue…

  2. Sezayi
    11/07/2013 at 09:32

    Teşekkürler. İşe yaradı. İyi çalışmalar.

  3. Amir
    10/01/2014 at 11:35

    Excellent. Thank you. You are of very great help

  4. Senthil
    26/05/2014 at 10:42

    Thanks dude

  5. Kumar
    12/01/2015 at 18:02

    Fantastic helps very much

  6. asit kaushik
    22/07/2015 at 08:28

    Thanks so much :)

  7. 28/07/2015 at 23:12

    THANK YOU! I don’t know what happened to change it, but for some reason the Ctrl-R on my computer became the ‘chord’ selection. You pointed me in the right direction to get it reset.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 964 other followers

%d bloggers like this: