Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

SqlPrompt 6.1 doesn't properly persist program Options

dpokludadpokluda Posts: 4 New member
edited September 30, 2013 11:07AM in SQL Prompt
Here is my scenario (properly worked in SqlPrompt 6.0):
    * STEP1: make sure my settings are valid in C:\Users\{my_user_name}\AppData\Local\Red Gate\SQL Prompt 6 * STEP2: open SSMS and go to SQL Prompt > Options and see that my settings are still there (I look at Aliases for example) close SSMS * STEP3: reopen SSMS and go to SQL Prompt > Options and see that all my settings are gone
I am using Windows 8.1 Enterprise (RTM build 9600) version 6.3.9600, SSMS version 11.0.3128.0, .NET Framework 4.0.30319.33440.

Any idea how to fix or workaround this issue? The only way I found to workaround this is to uninstall version 6.1 and go back to version 6.0. :(


  • Aaron LAaron L Posts: 596 New member
    Could you check your log file to see if it gives any reason for why it's failing to load the options.

    The logs can be found under %localappdata%\Red Gate\SQL Prompt 6 and you should see a line saying something like:
    "ERROR RedGate.SqlPrompt.Metadata.Options.OptionsBase - Error deserializing options for RedGate.SqlPrompt.Engine.EngineOptions. Resetting to defaults."
    followed by details of why it failed.
  • Aaron LAaron L Posts: 596 New member
    Sorry, I just realised you've sent in your log files to support already, I'm looking at them now and will try to get a fix soon.
  • Aaron LAaron L Posts: 596 New member
    Could you try build to see if this fixes the issue for you? Thanks!
  • dpokludadpokluda Posts: 4 New member
    I have installed the build mentioned here ( and so far it seems it resolved the issue. I will continue using this build and I will let you know if I see something not working properly.

    Thanks you very much for your quick response.
Sign In or Register to comment.