Options not being remembered / resets every time

JiriDolezal_AlzaCZ

My SQL Prompt options reset to default state (probably) EVERY time I start a new SSMS instance or say the same differently My SQL Prompt does not remember my options. It's over more versions of SQL Prompt (10.13.7 currently) and SSMS (18.12.1 currently).

Would you help please, it's so frustrating. Thanks

Dan_J

Hi @JiriDolezal_AlzaCZ

Our apology for the delay in resolving this!

We have been discussing and testing this with our development team over the last few weeks, and the latest response from them earlier this morning is that they suspect the issue could be being cause by two snippets with the same GUID.

Would you mind navigating to %localappdata%\Red Gate\SQL Prompt 10 and checking the Snippets folder for any duplicate snippets? I have included a Powershell script that will help to make this process quicker.

dkim1999

Hi there,

Thank you for reaching out and I apologize that you are running into issues with SQL Prompt.

Can you please try updating to the latest version of SQL Prompt as there were some fixes for settings not saving.

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.8.680.exe

Kind Regards,

David K

Product Support Engineer

JiriDolezal_AlzaCZ

The problem remains even after the installation of the new version 10.13.8.860

My simple test case scenario is:
- run SSMS
- go to SQL Prompt > Options > Aliases > turn off Assign aliases
- shut down SSMS
- run SSMS
- check for Assign aliases option > and it's On

JiriDolezal_AlzaCZ

This behavior continues on 10.13.10.1356 too (SSMS 18.12.1) :-(

JiriDolezal_AlzaCZ

Many thanks, David. It worked like a charm. There were duplicates in the snippets folder and your PS scripts solved it out. Consider this closed.

Dan_J

Hi @JiriDolezal_AlzaCZ

That's great news! I'm so glad this is now resolved for you.