VS2019 Prompt Settings Revert After Close

• 
  Hi @meldupl
  

  Just to advise that our development team are looking into this and have raised a Jira. I will update you again as soon as I have an update for on this.

  https://jira.red-gate.com/browse/TBE-33

  Victoria W January 23, 2023 13:31

  - 0 +
• 
  Hi @meldupl
  
  I'm happy to report that this bug has been fixed in the latest version of SQL Prompt:
  
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.5.16.exe
  

  Victoria W February 21, 2023 10:08

  - 0 +
• 
  still losing options after I restart SSMS.  Using SQL Prompt 10.13.5.16.  SSMS is version 18.12.1.  Also under Queries > Color > Edit Environments, I add an environment, click Save, but it does not stick.  I do run SSMS as a different user (not the user my Windows is running under), so I am wondering if it is saving the settings under my normal Window users folder under C:\Users.  It works just fine when I run SSMS under the account I am running Windows under

  jgonnering February 22, 2023 16:54

  - 0 +
• 
  I am having the same problem as jgonnering. I cannot make changes to coloring under Queries > Color. Whenever I make changes it just reverts them when I close the settings.

  ColinAnderson February 24, 2023 15:45

  - 0 +
• 
  Hi @ColinAnderson
  
  Regarding the SQL Prompt settings location, the file path is C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10 which the SSMS login user that is different from the windows user may not have permission to edit folders in.
   
  The article below covers how to change this location to a file path that may be more accessible.
  https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/changing-the-location-of-the-settings-and-snippet-folders
  

  Victoria W February 28, 2023 08:59

  - 0 +
• 
  Hi, I'm having the same problem as jgonnering and ColinAnderson. 
  SQL Prompt options reset after closing SSMS.
  Problem appears in Prompt version 10.13.5.16, SSMS login user is the same as windows user and it seems I do have permission to edit folders located in said path. 
  

  alice March 15, 2023 09:08

  - 0 +
• 
  Hi @alice
  

  The SQL Prompt settings location file path is C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10 which the SSMS login user that is different from the windows user may not have permission to edit folders in.

  The article below covers how to change this location to a file path that may be more accessible: https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/changing-the-location-of-the-settings-and-snippet-folders

  Victoria W March 16, 2023 10:26

  - 0 +
• 
  There is currently an issue where under certain circumstances some settings such as tab colors are not saving. The dev team are actively looking at a fix for this and it should hopefully be out soon. 
  
  You can manually edit this by changing the "ConnectionColoringCategories.xml" and "ConnectionColoringServers.xml" in %localappdata%/red gate/SQL Prompt 10

  ATurner March 23, 2023 16:02

  - 0 +
• 
  Hi, @ATurner ,

  Thank you for your reply. Since it was really annoying, I already changed xml files manually a few hours ago (ConnectionColoringCategories, ConnectionColoringServers and RedGate_SqlPrompt_Engine_EngineOptions).

  
  

  I double checked my user's permission, even compared it with my colleague's settings, and it seems that only I have such a problem. 

  alice March 23, 2023 16:16

  - 0 +
• 
  Hi All
  
  This should be fixed in the latest prompt release.

  ATurner April 03, 2023 14:45

  - 0 +
• 
  I have version latest version of SQL Prompt 10.13.7.360, and when I add new custom alias under "Inserted Code > Aliases" it does not persist them in the RedGate_SqlPrompt_Engine_EngineOptions.xml file.  When I close and reopen SSMS, the aliases are no longer there.  I have changed my options folder in the registry to a folder that the account has permissions to as described above.  I am running my SSMS as a different account than my Windows login.  The account I am running SSMS is a local admin account.  
  
  

  SQL Server Management Studio 15.0.18424.0 (version 18.12.1)

  SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1

  Microsoft Analysis Services Client Tools 15.0.19750.0

  Microsoft Data Access Components (MDAC) 10.0.22000.1574

  Microsoft MSXML 3.0 6.0 

  Microsoft .NET Framework 4.0.30319.42000

  Operating System 10.0.22000

  jgonnering April 10, 2023 15:30

  - 0 +

Add comment

Please sign in to leave a comment.