Bug Fix – Show Result Pane not working in SQL Server 2012 with CTRL + R

Bug Fix – Show Result Pane not working in SQL Server 2012 with CTRL + R

Once you are addicted with some keyboard short keys then you hate to use mouse for those things for sure. SQL Developer/DBA are, mostly, addicted with “CTRL + R” short key which is being used to show/hide result panel in SSMS.

I, many time, received question/complaint that CTRL+R is not working in SQL Server 2012’s SSMS, especially from the user who are using Windnows 7 (Windows 8 doesn’t have this behavior, at least for me).

Well, this is very known issue and there is a workaround for this. Let us see how shall we do this…..!!!

Once you open the SSMS, go to Tools | Customize.

1

Once you will get “Customize” dialog box, click on “Keyboard” button from the “Customize” dialog box.

2

Now you will be greeted with “Options” dialog box, where you have to select “Windows.ShowResultPane” option from listbox given under “Show Commands Containing”, select “SQL Query Editor” under “Use new Shortcut in”, also Press the short key you wanted to use (I have selected very known CTRL+R) under “Press shortcut keys” and click on “Assign” button and close the dialog box by clicking on “OK” button.

3

Now, you are there with your very own shortcut key “CTRL+R”. It will work in SSMS even in Windows 7.

Have you ever faced this issue?

If you like this article, do like “Extreme-Advice” page in Facebook.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles

Author: Riteshshah

Ritesh Shah is a database professional with having 16+ years of experience in various domain of IT field. He is a author of many technical articles on Microsoft Technology and authored a book of SQL Server 2012 Performance Tuning cookbook. He loves work with different Microsoft Products.

4 thoughts on “Bug Fix – Show Result Pane not working in SQL Server 2012 with CTRL + R”

Comments are closed.