After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like in early versions, and one of the most shortcut key that I had problem after my installation of the SQL Server 2012 in the SSMS has been well known shortcut Ctrl+R to remove the last results pane from the SSMS! Ok lets take a look few steps how to activate it in the new SSMS of the SQL Server 2012:
Select > Tools > Customize … click “Keyboard”
In the list window scroll down and find to select “Window.ShowResultsPane”
Go to “Use new shortcut in:” – select “SQL Query Editor”
Go to “Press shortcut keys” text box and press Ctrl+R
Click “Assign” and finally OK!
Now, when you execute a select statement in SSMS and you have results set, you can remove them, pressing Ctrl+R, that is very often used from the Developers and DBA to clear the results pane!
This is very little help and enjoy it!
Filed under: SQL 2012, SSC Tagged: Fast Learn, SQL Server 2012, Tips'n'Tricks