How can we help you today? How can we help you today?

Intellisense showing blank values for tables

I am using SQL Prompt 7.4.0.471 in SSMS 12.0.4100.1 and in the intellisense drop down, the table suggestions are blank. If I put my cursor over it, the table definition popup will appear next to it just fine.

I have a screen shot, but I'm not sure how to attach it.

If I have a statement like below, and I bring up SQL Prompt intellisense after the ON clause, all the column join suggestions (paper clip icon) are fine, but the table alias only (r, cr) are blank.
SELECT *
FROM dbo.Report as r
JOIN ClientReport as cr
ON
jgonnering
0

Comments

5 comments

Sort by
  • Harry Frankish
    Hi jgonnering

    Please could you email the screenshot to SqlPromptTeam@red-gate.com?

    Did this issue only start happening when you upgraded to 7.4.0.471?

    Cheers
    Harry
    Harry Frankish
    0
  • jgonnering
    Ok, I will email. The issue started with 7.4.0.245 (I was sent a link for this to solve another forum issue I submitted).
    jgonnering
    0
  • Michael Clark
    Thank you for your email, we have logged a bug SP-6079 and will let you know if we find a fix.

    Best,
    Michael
    Michael Clark
    0
  • Michael Clark
    Our latest SQL Prompt 7.4 beta fixes this issue:
    https://forums.red-gate.com/viewtopic.php?f=169&t=80560
    Michael Clark
    0
  • jgonnering
    I can confirm that the latest beta fixes the issue. Thank you! Case closed.
    jgonnering
    0

Add comment

Please sign in to leave a comment.