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?

Improve this question
1
  • 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
    Commented Jun 5, 2015 at 13:27

1 Answer 1

Reset to default
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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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