WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 516 reviews for our classroom and online training
What to do when you get red squiggly lines in SSMS and no Intellisense
Normally when SQL Server Management Studio underlines words with what Microsoft call "red squigglies" it's because you haven't refreshed your local cache, but it could also be because of a recent bug - here's how to get round this!

Posted by Sam Lowrie on 28 April 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Fake red squiggly error lines and no intellisense

Recently I had a strange encounter in SQL.  No, this isn't the start of a romance novel. Instead it was this:

SQL Intellisense Error Weird

Notice that the error is only showing for the column and not for the table. The code runs but thinks the column doesn't exist.

The first thing to check is that the local cache has been updated to include new objects via the Edit menu.

Refreshing local cache

The fact that the table was not underlined made me suspect this wasn't the problem.

Next I tried restarting the SQL services, restarting SSMS and even the computer - all to no avail.

SQL Intellisense Missing

The code would run but the Intellisense would not show the columns - and still the underline appeared.

It was by pure happenstance that my colleague Andrew had updated his version of Management Studio only days before. The latest patch notes described exactly the issue:

Intellisense issues

This isn't the first time an issue like this has reared its ugly head. However Google-ing the issue yielded no direct references.

One quick update later and the issue was gone! You can get details of the bug fix and update here.

This blog has 0 threads Add post