SSMS IntelliSense doesn't work on particular database
5
votes
1
answer
1791
views
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?
Asked by AlbertZOZ
(71 rep)
Jan 28, 2015, 10:15 PM
Last activity: Jan 26, 2018, 07:35 PM
Last activity: Jan 26, 2018, 07:35 PM