SQL Server with Mr. Denny

Jul 14 2011   2:56AM GMT

Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3

Denny Cherry Denny Cherry Profile: Denny Cherry


If you did what I did when you installed CTP 3 of SQL Server “Denali” (which happened when I uninstalled CTP 1 then installed CTP 3) you’ll be in for a rude surprise, a lot of your shortcut keys that you’ve been using for years don’t work any more.  This is to say the least VERY annoying, and shouldn’t have ever happened.  If you upgrade you won’t have this problem as it’ll take your old shortcut key settings.

It isn’t all that hard to fix, provided that you know what each and every hot key was supposed to be you can go into Tools > Options then Environment > Keyboard > General and reset all the keys that are hosed up.

Or you can download the settings file that I’ve put together that has (I think) all the screwed up hot keys corrected.  Safe this file on your computer somewhere and uncompress it, then click on Tools > Import and Export Settings.  Run through the wizard (be sure to safe your current settings in case it really screws something up) then import my file.  Now all your shortcut keys “should” work as expected.

If you find a shortcut key that I missed please put it in the comments below, or let me know in some other way and I’ll get the file updated.


P.S. I’ve sent a nasty note to some of my SQL Server development team contacts.  I’ve also submitted a connect item so that feedback can be publicly collected.

2  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Raan
    To venture a wild guess - could it be that by default, SSMS now has the same hot keys as VS? Like, execute would be CTRL+ALT+E instead of ALT+X, CTRL+E, CTRL+C will comment the selection etc.? That would actually make sense. I move between VS and SSMS a lot, and the difference is confusing. I would rather relearn and have one set. It would be nice though if they came up with a way to use the new hot keys in older versions of SSMS though...
    0 pointsBadges:
  • Denny Cherry
    Yep, that would be the exact problem. For people that move between SSMS and VS it makes sense to have the hot keys be the same. However for those of us that never work in VS we don't know or care about the VS hot keys. Since the VS hot keys are the ones which are now the defaults it makes it pretty hard to use SSMS. You can edit the vssetting file in SQL 2008 R2 and change the hot keys in there. In SQL Denali they put a UI in place to help with this.
    69,000 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: