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.
(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!
- SQL Server – Different Ways to Check Object Definition
- SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
- SQL Server – How to get last access/update time for a table
- SQL Server – Displaying line numbers in Query Editor – SSMS
- SQL Server – Difference between @@CONNECTIONS and @@MAX_CONNECTIONS
- SQL Server – Different ways to check Recovery Model of a database
- SQL Server – Calculating elapsed time from DATETIME
- SQL Server – Kill all sessions using database
- SQL Server – Custom sorting in ORDER BY clause
- SQL Server – Script to get Service Account for all local instances
This is a personal weblog. The opinions expressed here are my own and not of my employer. For accuracy and official references refer to MSDN, Microsoft TechNet, Books Online. I or my employer do not endorse any of the tools / applications / books / concepts mentioned here on my blog. I have simply documented my personal experiences on this blog.
- Backup & Recovery (11)
- Catalog Views (25)
- Certification (1)
- Common Table Expressions (6)
- Database Mail (1)
- Management Studio (38)
- Management Views and Functions (11)
- Partitioning (3)
- Service Pack Releases (2)
- SQL Agent (7)
- SQL Bugs (2)
- SQL Configuration (30)
- SQLServer (164)
- Uncategorized (1)
- Undocumented Functions (21)
- Working With Data (14)