BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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:
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.
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.
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:
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.