Background
If you deal with Microsoft SQL Management Studio, you’ll no doubt have come across the red squiggly line from IntelliSense that says ‘nope, I aiiiiiint got a clue what this is….’
yep – that thing, above ….
What’s happened is that intellisense only seems to get updated when you first load the query window, and is not aware of live changes (seems a bit silly … perhaps there a setting somewhere I haven’t found yet…) … anyway, a colleague gave me this trick a few years ago, and I was reminded of it today.
How To Fix
In the ‘Edit | Intellisense’ menu, locate ‘Refresh local cache’ (or click CTRL + SHIFT + R’, and your new object should appear. #LikeMagic
History
Allen is CTO of SocialVoice (https://www.socialvoice.ai), where his company analyses video data at scale and gives Global Brands Knowledge, Insights and Actions never seen before! Allen is a chartered engineer, a Fellow of the British Computing Society, a Microsoft mvp and Regional Director, and C-Sharp Corner Community Adviser and MVP. His core technology interests are BigData, IoT and Machine Learning.
When not chained to his desk he can be found fixing broken things, playing music very badly or trying to shape things out of wood. He currently completing a PhD in AI and is also a ball throwing slave for his dogs.