Home > Management Studio, SQL Configuration, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012 > SQL Server – Show/Hide Results Pane in Management Studio 2012

SQL Server – Show/Hide Results Pane in Management Studio 2012

In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard shortcut Ctrl+R. This shortcut was also present in Query Analyzer (SQL Server 2000).

This shortcut is no longer available in SQL Server Management Studio 2012. In this version you need to use Ctrl+Shift+Alt+R to show/hide query results pane. Another alternative shortcuts you can use to show or hide results pane is Alt+WS and Alt+WI respectively. I find the later to be more easy to use.

If you have gotten used to using old shortcut Ctrl+R you can customize shortcuts in SQL Server Management Studio.

To change keyboard shortcut for show/hide results pane:

Step 1: Go to Tools > Options in SQL Server Management Studio:


Step 2: Navigate to Environment > Keyboard > Keyboard


Step 3: Search for Window.ShowResultsPane using Show commands containing: textbox.


Step 4:

(1) Select Ctrl+Shift+Alt+R (SQL Query Editor) in Shortcuts for selected command: list.
(2) Select SQL Query Editor in Use new shortcut in: list.
(3) Go to Press shortcut keys: textbox and press Ctrl+R or any other shortcut you need.
(4) Click on Assign.
(5) Click on OK to apply changes.


Step 5: You need to restart SQL Server Management Studio to apply these changes.


Note: The Window menu will still show Ctrl+Shift+Alt+R as shortcut we have only added an additional shortcut, we have not removed existing shortcut.

Hope This Helps!


If you like this post, do like my Facebook Page -> SqlAndMe
EMail me your questions -> Vishal@SqlAndMe.com
Follow me on Twitter -> @SqlAndMe

  1. jjknj
    May 23, 2013 at 1:15 am

    nbvbmvjcfdug rrdcu dyr dutf y

  2. June 4, 2013 at 6:11 pm

    Not sure why they changed this because I’d imagine it was a pretty common shortcut… it certainly was for me! It’s interesting because I did the exact same thing as you except I didn’t do Step 4.2 (I had set to Global) and it wasn’t working for me. Thanks for the post!

  3. Microsoft Solution
    August 27, 2013 at 11:44 pm
  4. ralph
    October 11, 2013 at 3:18 am

    Thanks, while I am sure Ctrl+Shift+Alt+R is obvious to the genius’s who changed from Ctrl+R, I am not on that plane of intuitive intelligence. The change seems so arbitrary. It is certainly inconvenient. It kills productivity to stop and figure this out (thanks again for your help) or look this up.

  5. sami
    November 6, 2013 at 2:42 pm

    Gr8 stuff!!

  6. ram
    October 28, 2014 at 5:08 pm

    thanks for help. i am using cntrl+K,Cntrl+R for this command.

  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

%d bloggers like this: