Options
VS2019 Prompt Settings Revert After Close
meldupl
Posts: 1 New member
Currently have SQL Prompt for Visual Studio installed - every time I close VS the Prompt settings that I've changed reverts back to default settings. SQL Prompt version is 10.13.3.32087.
Any way to fix this? I've read a thread that suggested changing it on the SSMS instance of SQL Prompt but I do not have access to a local SSMS version to be able to do this.
Any way to fix this? I've read a thread that suggested changing it on the SSMS instance of SQL Prompt but I do not have access to a local SSMS version to be able to do this.
Tagged:
Answers
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 Wiseman | Redgate Software
Have you visited our Help Center?
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 Wiseman | Redgate Software
Have you visited our Help Center?
Regarding the SQL Prompt settings location, the file path is
C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10which 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 Wiseman | Redgate Software
Have you visited our Help Center?
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.
The SQL Prompt settings location file path is
C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10which 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 Wiseman | Redgate Software
Have you visited our Help Center?
You can manually edit this by changing the "ConnectionColoringCategories.xml" and "ConnectionColoringServers.xml" in %localappdata%/red gate/SQL Prompt 10
This should be fixed in the latest prompt release.