All geek questions in one place

SQL Server Intellisense does not work on * some * servers

Intellisense works ... On some servers. The same Server Management Studio (SQL Server 2008), which I use to manage servers, but Intellisense is not working on one of the new servers (not sure if other servers have the same problem, at the moment I only encountered this problem on one of the servers).

I checked all the settings, etc., but as I said, it works on some servers in SQL Server Server Studio, so it seems to be limited to this specific server.

(I wasn’t sure it was here. If this message is in the wrong place, move it)

+4
source share
2 answers

This question covers to make sure it is turned on, and it sounds like it is (I am tying it just in case). Sometimes there is also an installation problem with 2008 and Visual Studio 2010 (also mentioned in this link), and this question covers this. We had the same problem on one of the servers in 2008, and after the publication, an update was published (solution 2).

+2
source

In addition to some very common reasons (which do not apply here, as you say, they do not work only for some servers) listed here: http://msdn.microsoft.com/en-us/library/ks1ka3t6%28v=vs.90 % 29.aspx

... Recently, have you been able to install VS2010? There is an error due to which IntelliSense stops working ... http://support.microsoft.com/kb/2531482

Also try updating the IntelliSense cache after connecting to a new server (SSMS): Edit> IntelliSense> RefreshLocalCache

+1
source

Source: https://habr.com/ru/post/1014327/

More articles:


All Articles