Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « Standardize Table AliasesGiving only insert permissions to a table for a new login »
    comments

    Do you use Ctrl+R to hide or display the query results/messages pane in SSMS? Have you installed SSMS 2012 and find that it does not work? Does it drive you crazy because you think they pulled keyboard shortcut or because in some installs it works but not in others?

    Fear not, you can add this keyboard short-cut!

    1. In SSMS open the “Tools” menu and choose “Options…”.
    2. On the left, expand “Environment”, then expand “Keyboard” and then click on “Keyboard”.
    3. Choose “Window.ShowResultsPane” (you can type that into the “Show commands containing:” field to find it faster. Choose “SQL Query Editor” from the “Use new shortcut in:” drop down list.
    4. Click into the “Press shortcut keys:” field and press Ctrl and R at the same time (the field should update to show “Ctrl +R”.
    5. Review the “Shortcut currently used by:” dropdown list to ensure there are no other short cuts using Ctrl +R for SQL Query Editor.
    6. Click the Assign button and then the OK button.

    And presto, the Ctrl+R functionality to hide or display the query results/messages pane in SSMS!

    About the Author

    Kevin -=Conan The Canadian=- is a SQL Server geek and has been writing SQL queries for over 10 years. After spending 5 years developing, designing and tuning HighJump systems, he made the jump to become a full fledged DBA. Since that jump, he's created SSIS Packages, transactional replication, cross platform replication with DoubleTake, monitoring with Diagnostic Manager, and so much more!
    Social SitingsTwitterLTD RSS Feed
    2706 views
    ssms
    InstapaperVote on HN

    No feedback yet

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)