Lost the IntelliSense in SQL Server Management Studio

Question

I am running SQL-2008 R2 Server.

Usually when I write a query, I get a full-versed IntelliSense displaying all the objects in my Database.

But now when I was onto a task, it showed no IntelliSense. Instead, when I wrote the object names, it showed that object is invalid! However, running the Query gives correct results.

I shut-down the Management studio and restarted it. Now all works fine.

I wanna know what was actually wrong. Any ideas?

Answer 1

You probably needed to refresh it. Either

1. Go to Edit -> IntelliSense -> Refresh Local Cache
2. Use Ctrl+Shift+R