SQL Prompt suddenly stopped working in SSMS

• 
  Hi Barb,
  
  

  I'm sorry that you are experiencing some issues with the SQL Prompt tool.  This particular error might relate to a subfolder location being used for the Styles or Snippets.  When you un-install SQL Prompt, you may need to remove a couple of Registry Keys to restore the default paths prior to re-installing. 

  After un-installing SQL Prompt, to remove the relevant Windows Registry Keys, run Regedit.msc and browse to the following location:  Computer\HKEY_CURRENT_USER\SOFTWARE\Red Gate\SQL Prompt 10\

  You may see 2 entries, one for the Styles ("Formatting Styles Folder") and one for the Snippets folder ("Snippets Folder") - delete those keys if they exist.  Then re-install SQL Prompt.  This should restore the default folder locations.

  If the above fix doesn't resolve the issue - can you please send through the log files?  There is a mechanism to do this through the SQL Prompt GUI, however if this isn't loading you can look in the following folder for log files: %localappdata%\Red Gate\Logs\SQL Prompt 10

  Regards,

  David Harris.

  DavidHarris March 25, 2021 02:48

  - 0 +
• 
  I do not find any of the above steps useful. I have VM where I installed SQL Prompt, it only worked once.

  sammysung July 20, 2021 20:32

  - 0 +
• 
  After the first time I do not have any way to get SQL Prompt working, Non of the SQL Prompt menus do anything in the SSMS when I click any of the menus

  sammysung July 20, 2021 20:34

  - 0 +
• 
  Hi @sammysung,
  
  Sorry to hear that!
  
  Just to confirm, are you seeing the same "Object reference not set to an instance of an object" error?
  
  We've seen some issues when users have their Snippets location pointing to a folder that also contains their style files (either directly or as a sub-folder). Can I check if that's the case?

  Jessica R July 30, 2021 01:16

  - 0 +

Add comment

Please sign in to leave a comment.