aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SSMS 2014 Ctrl+R Shortcut to Show or Hide Query Results Pane

May 9, 2016

Here I will explain enable Ctrl + R shortcut to show or hide results pane in
sql server or Ctrl + R shortcut key to show / hide results pane missing in ssms 2014 or Ctrl + R shortcut key not working in ssms 2014 to show or hide results pane. In sql server 2014 Ctrl + R option to show or hide results pane has been disabled by default so we need to enable it manually by changing options of ssms 2014.

In sql server 2014 the shortcut Ctrl + R missing to show / hide results pane because of that we need to enable that Ctrl + R shortcut manually for that we need to follow below steps.

1. Open ssms 2014 and go to Tools à click on Options

2. Now in left side menu expand Environment à then expand Keyboard à then select keyboard like as shown below

3. Now search for Window.ShowResultsPane from “show commands containing” search textbox and select “Window.ShowResultsPane” and select “SQL Query Editor” from “Use new shortcut in” dropdown list.

4. Now click in “Press shortcut keys” textbox and press Ctrl + R keys at a time to set shortcut key once we pressed that filed will update with Ctrl + R shortcut.

5. To ensure no other shortcuts using Ctrl + R check shortcut currently used by dropdown list and click Assign button like as shown below

6. Once we assign shortcut key now click ok button like as shown below

That’s it we set shortcut key to show or hide results pane in sql server 2014.

I hope it helps you to set shortcut key Ctrl + R to show or hide results pane in sql server.

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.