CODEWITHSUNDEEP
sql-serverssmsssms-2014
Mohit Vijay
Mohit Vijay

Reputation: 39

Intellisense is not working in SQL Server 2014

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

Upvotes: 1

Views: 7404

Answers (4)

user15037435
user15037435

Reputation:

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

Upvotes: 0

user10621704
user10621704

Reputation: 11

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.

Upvotes: 1

Evaldas Buinauskas
Evaldas Buinauskas

Reputation: 14077

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.

Upvotes: 4

vinay koul
vinay koul

Reputation: 346

Perform following steps:

Under Edit -> IntelliSense -> Refresh Local Cache

Restart SSMS.Then try

Upvotes: 3

Related Questions