no tables in code suggestions after upgrade to

After upgrading to SQL Prompt, 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.

Best Answer


  • Options
    MichaelHowardMichaelHoward Posts: 2 New member
    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.
  • Options
    That's great to hear, SQL Prompt should certainly be up and running with all versions of SSMS18-20 now.
    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.