Options
Column Picker Stopped Working for Azure Servers (PaaS)
Davidian
Posts: 11 New member
in SQL Prompt
I've recently been sent a new laptop from work so as part of that I had the latest SSMS and Redgate installed
For some reason the column picker etc no longer works on Redgate: SSMS 19.3 - SQL Prompt: 10.14.5.5385
However, I noticed it has worked for our Azure IaaS SQL Servers, just not our Azure PaaS - which typically is what I use most.
As part of the debug process I loaded up my old laptop which still had SSMS 19.1 installed though I think SQL prompt was up to date.
The column picker worked until i did a "refresh suggestions" at which point all options for our PaaS servers disappeared.
It would seem the issue is with Prompt and not necessarily a compatibility issue with SSMS
For some reason the column picker etc no longer works on Redgate: SSMS 19.3 - SQL Prompt: 10.14.5.5385
However, I noticed it has worked for our Azure IaaS SQL Servers, just not our Azure PaaS - which typically is what I use most.
As part of the debug process I loaded up my old laptop which still had SSMS 19.1 installed though I think SQL prompt was up to date.
The column picker worked until i did a "refresh suggestions" at which point all options for our PaaS servers disappeared.
It would seem the issue is with Prompt and not necessarily a compatibility issue with SSMS
Best Answers
-
OptionsAlanGraham
Posts: 4 Bronze 1
Having this same problem. I uninstalled prompt 10.14.5.5385 and downgraded to 10.14.4.4865 and all is well.
Had to find the link here:
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-14-release-notes
-
OptionsDavidian
Posts: 11 New member
Just wanted to confirm: 10.14.4.4865 works
It took me refreshing a few times, both the connection and the suggestions, but they populated after that - and yes, I tried this on the other versions too but without much avail.
Hopefully Redgate get this resolved in their next release.
Answers
10.14.6.5992 - Released on 24 January 2024
Still doesn't work with PaaS
Going to try downgrading like you suggest now.
We've rolled out the latest version of SQL Prompt: (10.14.7.6275 ) on January 31st. Could you kindly verify if this update has effectively addressed the concerns regarding PaaS Servers?
Please let me know if the issue persists
Best,
Hassan
Product Support Engineer
I don't have the time to update and test right now, because if it doesn't work there isn't a "downgrade" option, you have to uninstall and reinstall and believe it or not, I am up against the wall at the moment.