Intellisense is not working in SQL Server 2014

Question

Intellisense is not working in Microsoft SQL Server 2014, it was working fine in Microsoft SQL Server 2012 but once I installed 2014 it is not working.

Under Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense it says it is enabled there.

I have also tried refeshing the IntelliSense cache with Ctrl-Shft-R but that doesn't work.

Answer 1

From my personal experience, SSMS IntelliSense is a pure crap, sometimes it works, sometimes it doesn't. I'd go for third party tools.

If you're willing to spend your cash, I'd recommend Redgate SQL Prompt.
If you need a free product, try dbForge SQL Complete, it's not as good as SQL Prompt, but does a decent job.

Answer 2

Perform following steps:

Under Edit -> IntelliSense -> Refresh Local Cache

Restart SSMS.Then try

Answer 3

After Refreshing local cache, if still not working, then try to delete temporary file of OS. for me it's work, I hope this will fix your's issue as well.

Answer 4

I am with SQL Server Management Studio 2014 and this working "Just hit Ctrl+Shift+R to force SSMS to refresh its cache." – Panagiotis Kanavos