问题:

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.

回答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.

回答2:

Perform following steps:

Under Edit -> IntelliSense -> Refresh Local Cache

Restart SSMS.Then try

回答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.