Keyboard shortcut to reformat code quit working

• 
  Hi Steve,
  
  Is it just the Format SQL shortcut that has stopped working or have all the keyboard commands stopped? If you right click on a query window are any shortcuts listed?
  
  
  Thanks,
  Aaron.

  Aaron L August 10, 2015 08:05

  - 0 +
• 
  I noticed the same problem. Yes, it coincided with the install of SSMS 2016 CTP 2. All my SQL Prompt key shortcuts are gone. Is there an easy way to restore them?

  KevinGreiner August 27, 2015 15:27

  - 0 +
• 
  Hi Kevin,
  
  SQL Prompt should set the keyboard shortcuts on startup if they aren't correct - Installing a new SSMS might have caused a few things to get reset but Prompt should re-bind the keyboard shortcuts.
  
  Could you try enabling verbose logging (Prompt->Help->Enable Verbose Logging) then restart SSMS and have a look at the log (Prompt->Help->Show Log) if you search for FormatSQL you should see some lines that look like:

  28 Aug 2015 08:04:36,841 [1] DEBUG RedGate.SQLPrompt.CommonVS.Commands.VSCommandController - GetOrCreateDteCommand - CreateIfNotPresent command LicensedFeature(DefaultCommandImpl(name: FormatSQL), status=>Visible)
  28 Aug 2015 08:04:36,842 [1] DEBUG RedGate.SQLPrompt.CommonVS.Commands.VSCommandController - DTE command already exists for LicensedFeature(DefaultCommandImpl(name: FormatSQL), status=>Visible) with bindings (SQL Query Editor::Ctrl+K, Ctrl+Y|SQL Query Editor::Ctrl+B, Ctrl+L)
  

  I'm wondering what yours look like?
  
  Thanks,
  Aaron.

  Aaron L August 28, 2015 04:09

  - 0 +
• 
  Restarting SSMS 2012 rebound the keys to their defaults. Which is good...
  
  However, I prefer FormatSQL bound to Ctrl-KD, just like Visual Studio. I also remove the Ctrl-BL and Ctrl-KY bindings to teach my muscle memory to always use Ctrl-KD.
  
  Unfortunately, SQL Prompt appears to wipe out this change, replacing my keys with its defaults.

  KevinGreiner August 28, 2015 09:11

  - 0 +
• 
  Hi Kevin,
  
  It's possible to change what these defaults are if you're happy to edit an xml file as described here. (but with editing the same xml file in the Prompt 7 local app data and using SQL::Ctrl+K,Ctrl+D)
  
  Hopefully the next version of SSMS will support extensions (currently only addins are loaded) which has a more reliable command system that'll allow you to rebind them using the standard options in SSMS.
  
  Let me know if you have any difficulty with rebinding the shortcuts.
  
  Thanks,
  Aaron.

  Aaron L August 28, 2015 09:25

  - 0 +
• 
  That worked. Thanks for your help.

  KevinGreiner August 28, 2015 09:40

  - 0 +

Add comment

Please sign in to leave a comment.