no tables in code suggestions after upgrade to 10.14.14.8187

MichaelHoward

After upgrading to SQL Prompt 10.14.14.8187, in an SSMS select statement I only get suggestions for the three default schemas (dbo, sys, master) but no specific tables within those schemas or any other schemas that exist in my database.

When I try to explicitly Refresh Suggestions, a progress bar saying "Connecting..." appears.  No progress on the progress bar is registered, but eventually the progress bar disappears.  The time it takes for the progress bar to disappear seems to correspond to the Execution timeout in seconds specified on the Suggestions > Connections tab of the SQL Prompt Options.

Ben_P

Hi Michael,

Thank you for your post. Are you using SSMS 18.12.1? If you are then there appears to be an issue currently with the latest version of SQL Prompt and SSMS 18.12.1. For now, the workaround is to roll back to SQL Prompt 10.14.10 as this would be before any changes were made to allow SQL Prompt to work in SSMS 20:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.10.7538.exe

MichaelHoward

I am using SSMS 18.12.1, but I actually got it to work by just uninstalling and reinstalling the latest SQL Prompt.  In the interim, I also installed SSMS 20, but SQL Prompt for now seems to be working in both SSMS 18 and 20.  Thanks for your help.

Jon_Kirkwood

That's great to hear, SQL Prompt should certainly be up and running with all versions of SSMS18-20 now.