My SSMS crashed and upon opening it back up SQL prompt crashed with that error. This issue has persisted through starting and restarting the app and the machine.
Edit: It looks like SQL Prompt tried to create a JSON version of my settings multiple times and and as a result found a style file of the expected name already existed
Comments
6 comments
-
Hi @jshafran
Please can you provide the SQL Prompt logs for troubleshooting.
https://documentation.red-gate.com/sp9/troubleshooting/finding-the-sql-prompt-log-files
Could you also send us the SQL Prompt folder from the location: C:\Users\<username>\AppData\Local\Red Gate\
-
I am having the same problem. Is there a resolution?
-
Also I tried to get the logs as you reference above, but nothing happens when I click the Menu command.
-
Hi @jettrooper
Please can you provide the SQL Prompt logs so that we can troubleshoot:
https://documentation.red-gate.com/sp9/troubleshooting/finding-the-sql-prompt-log-files
Can you also send us the SQL Prompt folder from the location: C:\Users\<username>\AppData\Local\Red Gate\
You can create a support ticket to send over the logs if you'd prefer:
https://productsupport.red-gate.com/hc/en-us/requests/new
-
As I mentioned above. Nothing happens when I click the Sow Logs command. How do you want the folder? Just a screenshot I presume:
-
I had the same issue, but appear to have found a way to overcome it, whether this is a solution I'm unsure, it just worked for me.
In SSMS: Open SQL Prompt > Edit Formatting Styles ...
Once the Formatting Styles window opens, on the top left under Your Styles, I found two styles named the same. Both were identical when examined, so I simply chose one of them and deleted it from within that window.
SSMS now starts normally and all SQL Prompt functionality is restored.
I have no idea how the duplicate file was created.
Add comment
Please sign in to leave a comment.