no tables in code suggestions after upgrade to 10.14.14.8187
MichaelHoward
Posts: 2 New member
in SQL Prompt
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.
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.
Tagged:
Best Answer
-
Ben_P Posts: 231 Silver 2Hi 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
Answers