I dont know if this question is asked - I found similar question - How to enable intellisense, but my case is little different.

We have 2 SQL Servers 2012 - one is in the other room, other is in our Data Center.

When we write a query on our "next door" SQL Server intellisense working perfectly.

When we write a query on out DC SQL Server intellisense is not wokring - in a new window it works from time to time and does not underline wrong table names. In a window with big script does not working at all.

The DC server is newer version. SSMS lacks SP.

What can cause such issue? Any ideas?


Your Answer

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

Browse other questions tagged or ask your own question.