Archive

Posts Tagged ‘Fast Learn’

Ctrl+R in SSMS 2012

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!

Stay Tuned…!

Follow

Get every new post delivered to your Inbox.

Join 880 other followers