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.
Once you will get “Customize” dialog box, click on “Keyboard” button from the “Customize” dialog box.
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.
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?
Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles