SSMS Hotkeys

MelB

The latest version of SQL Prompt has overwritten the hotkeys used by SQL Server Management Studio. I and my colleagues use these keys often. Please give them back. I miss them terribly.

The most common ones are,

<Ctrl><Shift><P> - in SSMS this opens a SQL template

<F2> - in SSMS this navigates the query editor to a saved bookmark

Aaron L

Hi MelB,

I'm sorry Prompt has taken over your hotkeys!

Could I ask which version of SSMS you're currently using and were these custom hotkeys or did they come as SSMS defaults? We thought that they were unused by default.

Thanks,
Aaron.

MelB

Hi Aaron, thanks for the quick response. I should have checked the forum while on vacation.

These are the default hotkeys in SSMS since SQL 2000. This is a keyboard option that can be set through the following menu commands.

Tools > Options > Environment > Keyboard > Keyboard Scheme > SQL Server 2000

I'm still working on getting hotkeys to work properly in SSMS 2008 and later versions, but I'm sure there's a way.

I have loved hotkeys every since I cut my eyeteeth on green-screen DOS decades ago. It would be great if I didn't have to learn a new set over the old set.

Aaron L

Hi MelB,

Thanks for the extra info - I had completely missed that you could use the sql2000 scheme in 2008. It looks like Microsoft hasn't given an alternative for what ctrl+shift+p used to do, so it's not just a matter of leaning the new hotkeys either.

I think the best approach here would be to allow you to customize the Prompt keyboard bindings to avoid this conflict. Unfortunately most of them are hardcoded in the current build so I'll have a look into configuring them from a file. Hopefully I'll have a new build for you to try tomorrow.

Thanks,
Aaron.

MelB

Yes, yes, thank you, thank you!

Aaron L

Hi MelB,

I've made a private build for you here which allows you to override the keyboard bindings from an options file. There's no UI at the moment, so it'll involve manually editing the file:

1) Open %localappdata%Red GateSQL Prompt 6RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml
2) Add the following anywhere under the <UIOptions>...</UIOptions> tags:

<KeyboardBindingOverrides version="1" type="RedGate.SQLPrompt.CommonUI.Options.KeyboardBindingOverrides">
  <Overrides type="Overrides" version="2">
    <value version="1" type="Override">
      <CommandName>TogglePromptEnable</CommandName>
      <Bindings />
    </value>
    <value version="1" type="Override">
      <CommandName>Rename</CommandName>
      <Bindings>SQL::Ctrl+B, Ctrl+R</Bindings>
    </value>
  </Overrides>
</KeyboardBindingOverrides>

3) Start SSMS and set the keyboard scheme to sql2000

This will remove the binding for enabling/disabling Prompt and set the rename variable/alias command to "Ctrl+B, Ctrl+R".
Sorry it's a little fiddly, if you have any problems with it just let me know!

We'll include this in the next stable release of Prompt so the next time you upgrade it should keep the re-bindings and allow you to continue using the sql2000 scheme.

Thanks,
Aaron.

MelB

Thanks, Aaron!

I'll try this update when the developers are off of the terminal server.

...Mel