Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
538 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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! |
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.
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.