3

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?

  • If you type dbo. and then just wait, does a list eventually show up? Give it time. It may be a connectivity issue. Also see this tip for other potential ideas (it's labeled as 2012-specific but it's really not). – Aaron Bertrand Jun 5 '15 at 13:27
1

Well, I'm a little ashamed... SQL Server 2014 SP1 was not installed on my client machine. Doing so seems to fix the problem with SSMS Intellisense.

  • 1
    Client tools should always be >= version/SP of the highest server you manage. – Aaron Bertrand Jun 5 '15 at 13:59
  • SP1 is not installed the server yet, we will do it soon. – MaxiWheat Jun 5 '15 at 14:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.