CODEWITHSUNDEEP
sql-serverssmsintellisense
Isomil
Isomil

Reputation: 121

Intellisense Not Working SSMS 2014

I know there are a lot of posts on this issue, however I am unable to find a resolution to my issues.

Running: SMS 2014 with CU1 - Version 10.0.2342.0 on both SSMS and Client Tools. Visual Studio 2010 SP1 - 10.0.40219.1 SP1Rel

Connecting to: Server 2008 R2 SP2 CU 5 - 10.50.4276

Have Verified: IntelliSense in enabled. SQLCMD Mode is disabled. Have Refreshed Cache. Verified IntelliSense settings. Server does not support contained databases so this was ruled out.

Behavior:

Intellisense autopopulates and functions normally. All the tables are listed and the additional databases on the server.

Neither parameters or tables autopopulate and CTRL-J does not do anything.

Anyone have any other ideas to try? SSMS 2008 R2 worked fine across all the databases.

Upvotes: 12

Views: 3438

Answers (2)

zgb
zgb

Reputation: 141

Offline Linked Server can cause such behavior. Reconfigure or remove unreachable Linked server(s) and refresh Intellisense Local Cache with Ctrl+Shift+R.

Background of this solution: If your database has objects referencing offline Linked server, Intellisense is waiting for a resource which can't update and stops working.

Upvotes: 0

Selim Balci
Selim Balci

Reputation: 910

You could try refreshing the local cache by pressing CTRL + Shift + R buttons and wait for a while.

Upvotes: 1

Related Questions