sql-serverssmsssms-2012

Autocomplete table names are not showing up


My tables suggestions aren't populating when writing select statements. This only happens when I'm using my work VPN. How can I get the table name suggestions to appear?

My thought was that it would be network related, but my internet speed is very fast so I'm not sure what could be bottle-necking the issue if that is the problem.

I've already tried refreshing the tables, and messing with the autocomplete and intellisense settings.

Expect: populated list of tables as suggestions based on query.


Solution

  • SSMS intellisence has always been flaky. You've already done everything that can be done to force its hand. It may be better with newer versions (aside from interacting with SSIS, newer versions of SSMs will work perfectly fine with older releases of SQL Server), so give that a try. It'll install in parallel with your current version so there's no risk.