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

SQL Prompt 10.14.21.9884 always showing multi-part identifier could not be found

SQL Prompt, 10.14.21.9884, SSMS 20.1.10.0.

I typically leave solution files/tabs open between launches. When I launch SSMS and select an existing tab (which shows it is connected) I can execute the query and have success, but SQL Prompt keeps all the SQL statements underlined in red. This hasn't happened before.

If I copy the SQL out, close the tab, and then right-click the database and get a new connection, paste the SQL back in, the red lines are gone.
jsreynolds1
0

Comments

2 comments

Sort by
  • cperez
    Hi jsreynolds,

    Thanks for reaching out to Redgate Support.

    I suspect that intellisense may be underlining those statements. If you go to Open Tools>Options>Text Editor>Transact-SQL>Intellisense. Is Intellisense disabled here?

    You can see a sub-setting 'Underline error' that's the option which I believe is causing the issue for you. If you disable this and close and reopen SSMS are you still seeing the same behavior?
    cperez
    0
  • jsreynolds1
    @cperez Your suggestion was spot on. I thought I had turned off that stuff long ago, but indeed it was present. That fixed things. Sorry, and thank you.
    jsreynolds1
    0

Add comment

Please sign in to leave a comment.