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?