Sample Header Ad - 728x90

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