Thursday, March 12, 2009

Getting back the Ctrl-N shortcut with SQL Server 2008’s SSMS

After I installed SQL Server 2008, I noticed that the Ctrl-N keyboard shortcut in the SQL Server Management Studio (SSMS) no longer worked.  What it’s supposed to do is to open up a new query tab.  In my install of SSMS 2008, the Ctrl-N key did nothing.  Pressing Ctrl-N was burned into my brain. It was a serious context switch for me to have to select a menu item or press a button to get a new query tab. 

A friend of mine gave me a simple tip that fixed it.  Change the keyboard layout to “SQL Server 2000” and then back to “Standard” and that will restore the default keyboard mappings.  That fixed it and I belatedly found it documented here, here and here.  I don’t know why I didn’t check the series of tubes for the answer, it was pretty obvious how to fix it.

To change the keyboard mappings, select Tools->Options from the SSMS menu and then go to Environment->Keyboard.  From that spot, you can change the keyboard layout.  Change the layout and press the “Ok” button to save the changes.  Then, repeat the steps and select the standard layout and press “Ok” again.  That will set the default keyboard mappings, which will include the Ctrl-N mapping.

7 comments:

  1. Thanks a lot. Very helpful. Its a pity that Ctrl+N was not there in the first place.

    ReplyDelete
  2. Thanks, man. This helped me.

    ReplyDelete
  3. Thanks I was pulling my hairs to get ctrl+n working!

    http://www.naplantest.com.au

    ReplyDelete
  4. Great, thank you very much !

    Another great idea is how to change the ‘Edit Top 200 Rows' menu option:

    http://bradmarsh.net/index.php/2008/04/21/sql-2008-change-edit-top-200-rows/

    ReplyDelete
  5. Istvan Orendi3/01/2011 2:57 AM

    Nice post!
    Very Useful!

    ReplyDelete
  6. Pfhew... thanks. I kept hitting ctrl-n repeatedly each time before grabbing the mouse with a grunt.

    ReplyDelete

Note: Only a member of this blog may post a comment.