SQL Prompt 10.1.1 Error and Locks up SSMS

alphonseg

I just updated to SQL Prompt 10.1.1. Now when I open SSMS (17 or 18), I get the error
Failed to load 'C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml'.
The file exists and looks fine. All worked well before the update.
SSMS then locks up and I can't do anything at all.
How can I revert back to 10.1.0?

cmfox1970

alphonseg said:

I just updated to SQL Prompt 10.1.1. Now when I open SSMS (17 or 18), I get the error
Failed to load 'C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml'.
The file exists and looks fine. All worked well before the update.
SSMS then locks up and I can't do anything at all.
How can I revert back to 10.1.0?

I'm experiencing the exact same issue. I also receive an error trying to send the error notification to Red Gate.

alphonseg

I had just done a Windows 10 update this morning also, so I was able to use the restore point to restore my machine back, which included SQL Prompt 10.1.0, so I'm able to get back to work.

cmfox1970

alphonseg said:

I had just done a Windows 10 update this morning also, so I was able to use the restore point to restore my machine back, which included SQL Prompt 10.1.0, so I'm able to get back to work.

I uninstalled SQL Prompt and when I downloaded the latest version from Red Gate it installed 10.1.0.

alphonseg

Now, that's interesting!

corey

My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml

Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

cmfox1970

corey said:

My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml

Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

Try this - https://download.red-gate.com/SQLDeveloperBundle.exe

Also, restore the app data if you can so all your settings are still there.

corey

cmfox1970 said:

corey said:

My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml

Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

Try this - https://download.red-gate.com/SQLDeveloperBundle.exe

Also, restore the app data if you can so all your settings are still there.

Installed this and restored my previous settings and everything is good to go.

Thank you.

AdrianB

Thanks for getting in touch. We are aware of an issue with SQL Prompt v10.1.1 and are currently looking into it. We will post an update when we have a fix.

jsreynolds1

Guys, I think this must be a typo?

AdrianB

Yes, that is a typo. Well spotted, and thanks for letting us know. I've just fixed it.

jsreynolds1

Good morning all, should we consider SQL Prompt v10.1.2 a fix for the issue listed above?

AdrianB

Yes, it should be.