What are the challenges you face when working across database platforms? Take the survey

Setting are not saved

NatanDNatanD Posts: 3 New member
edited August 27, 2023 7:27AM in SQL Prompt
I change the "ConnectionColoringServers" settings and they are not savedת
only if I manually update the XML files in "%localappdata%\Red Gate\SQL Prompt 10".

Installed version:

Best Answer

  • Options
    ATurnerATurner Posts: 198 Silver 2
    Hi NatanD

    Could you check in the "snippets" folder located in "%localappdata%\Red Gate\SQL Prompt 10". That there are no duplicate GUIDS?


  • Options
    NatanDNatanD Posts: 3 New member
    Yes. I found 1 duplicate GUID.
    I fixed it, and now it works fine.
    Thank you!

    Note. The snippets folder is a network-shared folder.

    var dup = Directory.GetFiles(dirPath)
        .Select(f => f.Substring(f.IndexOf('-') + 1))
        .GroupBy(f => f)
        .Where(g => g.Count() > 1)
        .Select(f => f.Key)

Sign In or Register to comment.