Crash on Startup- "Cannot create a file when tha file already exists"
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
Tagged:
Answers
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\
Victoria Wiseman | Redgate Software
Have you visited our Help Center?
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
Victoria Wiseman | Redgate Software
Have you visited our Help Center?
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.