SQL Prompt menu not available in SSMS

• 
  Hi Jesus,
  
  There is an option in one of our XML configuration files called AlwaysRecreateCommands that might help with this. If you set the value to True, does this get the menu back?
  
  The XML file can be found in %localappdata%Red GateSQL Prompt 7 and is called RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml
  
  Best regards,
  
  David

  David Priddle September 30, 2016 06:59

  - 0 +
• 
  Hello David...
  
  I checked into that option on the XML configuration file (RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml), and the value for the option "AlwaysRecreateCommands" was False, so I changed to True, restart SSMS and then the "SQL Prompt" came back again.
  
  This helps to recover the "SQL Prompth" menu!
  
  One last question:
  - Is it OK to change the shortcut letter on the "SQL Prompt" menu?, on previous versions of SSMS it used to be the letter "S", but now is set on the letter "o": SQL Pr&ompt
  - If this change is possible to do, I see 2 items listed for "SQL Prompt" under the Controls list, should I need to change the shortcut letter for both?
  
  Thanks for your help!
  Regards...

  jesus_varela September 30, 2016 10:08

  - 0 +
• 
  Hello, I have above option and it is still not working me to connect. I tired to uninstall and reinstalled, but there is no progress. I am using SSMS 2014

  saravanakumar September 09, 2019 15:34

  - 0 +
• 
  I have the same problem as @saravanakumar. I have SSMS 2014 and red gate SQL Prompt stopped working for me. I uninstalled and reinstalled the extension and now the sql prompt menu is gone. please help
  

  theDeveloper October 12, 2020 17:17

  - 0 +

Add comment

Please sign in to leave a comment.