Intellisense is not working in SQL Server 2014

2019-06-08 02:05发布

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.

enter image description here

3条回答
疯言疯语
2楼-- · 2019-06-08 02:32

Perform following steps:

Under Edit -> IntelliSense -> Refresh Local Cache

Restart SSMS.Then try

查看更多
一纸荒年 Trace。
3楼-- · 2019-06-08 02:39

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.

查看更多
Deceive 欺骗
4楼-- · 2019-06-08 02:48

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.

查看更多
登录 后发表回答