Activity overview
Latest activity by 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 [image]
Try this - https://download.red-gate.com/SQLDeveloperBundle.exe Also, restore the app data if you can so all your settings are still there. / comments
corey said:
My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xmlTried uninstalling and clearing the appdata and then reinstal...
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. / comments
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 ...
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. / comments
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\ConnectionCol...
I just updated to 9.4.5.7296 and it looks like it didn't fix the issue of removing aliases from a table valued function's argument list. However, instead of stripping them completely it's sometimes leaving one on and other times it removes them all. For example, this: CROSS APPLY dbo.FormatTIN(I.TIN, I.TIN_TYPE) AS FT<br> reformats as this: CROSS APPLY dbo.FormatTIN(I.TIN, TIN_TYPE) AS FT<br> But this: CROSS APPLY dbo.FormatPhoneNbr(P.AREA_CODE, P.PREFIX, P.NUMBER, 1) AS FPN<br><br> reformats as this: CROSS APPLY dbo.FormatPhoneNbr(AREA_CODE, PREFIX, NUMBER, 1) AS FPN / comments
I just updated to 9.4.5.7296 and it looks like it didn't fix the issue of removing aliases from a table valued function's argument list. However, instead of stripping them completely it's sometimes...
Any progress on this? / comments
Any progress on this?