SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center.

So far I found one database (database A) doesn't have IntelliSense working, for exampletyping:

SELECT [put cursor here] FROM sys.objects

and moving cursor between select and from, pressing CTRL + J, I can see popup options for other databases, just not for database A. I have checked all options and refresh local cache, all don't work, and I am using an account which has sysadmin permission.

• The compatibility level is 11.0

• Version is

Microsoft SQL Server 2012 - 11.0.5556.0 (X64) Oct 31 2014 16:50:24 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: )

I can log on to the db server which is in US and see IntelliSense working there, it just doesn't on my desktop (in Australia). Is it most likely a latency issue? is there a timeout limit or setting for this feature?

It might be latency, or it might be something else. Run a SQL Server Profiler trace on the remote DB, starting the trace just prior to connecting via SSMS remotely. IntelliSense works by running queries to get the meta-data, so you will be able to see if it is even attempting to work or not, and if so, potentially if it is running into any problems.

You should filter the ApplicationName column on LIKE %IntelliSense%, though the full name of the program is Microsoft SQL Server Management Studio - Transact-SQL IntelliSense. Events to select: SQL:BatchStarting, SQL:BatchCompleted, SQL:StmtStarting, SQL:StmtCompleted, SP:Starting, SP:Completed, SP:StmtStarting, SP:StmtCompleted, RPC:Starting, and RPC:Completed.

Try it first on a DB that works so you know what the normal / expected behavior should look like. Hitting Control + Shift + R to force a reload of the local cache should produce a decent amount of activity captured by your trace.

StackExchange Database Administrators Q#90475, answer score: 6