How can we help you today? How can we help you today?

Options not being remembered / resets every time

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
Jiri Dolezal
0

Comments

6 comments

  • 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.

    Kind Regards,
    David K
    Product Support Engineer

    dkim1999
    0
  • 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
    0
  • JiriDolezal_AlzaCZ
    This behavior continues on 10.13.10.1356 too (SSMS 18.12.1) :-(
    JiriDolezal_AlzaCZ
    0
  • 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.
    Dan_J
    0
  • 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.
    JiriDolezal_AlzaCZ
    0
  • Dan_J
    Hi @JiriDolezal_AlzaCZ

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

Add comment

Please sign in to leave a comment.