We recently upgraded our production server to SQL Server 2014. This server hosts ~2200 databases. When I connect to it as
sa with SQL Server Management Studio 2014 and I type queries, Intellisense does not work (nothing show up). Before the upgrade, we ran SQL Server 2008 and SSMS 2008 and Intellisense was working perfectly in the same conditions. Also, Intellisense works when connected to an other server (our development server, SQL 2014 too) which holds ~10 databases.
- I already made sure Intellisense is enabled
- I already tried to Refresh the local cache (CTRL-Shift-R)
Am I missing something else? Or does it have something to do with the number of databases on the server? If so, why was that not happening before, with SQL Server 2008?