SQL server–show/hide Results Pane in Management Studio 2012

In earlier version of SQL Server Management Studio (2005, $ R2) You can show/hide Results pane using keyboard Shortcut ctrl+r . This shortcut is also present in Query Analyzer (SQL Server 2000).

This shortcut was no longer available in SQL Server Management Studio 2012. In the this version of need to use ctrl+shift+alt+r to show/hide Query Results pane. Another alternative shortcuts you can use-Show or hide Results pane is alt+wsand alt+wi resp Ectively. I find the later to is more easy-to-use.

If you had gotten used to using the 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 would still show Ctrl+shift+alt+r as shortcut we have only added an additional shortcut, We have not removed existing shortcut.

SQL server–show/hide Results Pane in Management Studio 2012