title: Invalid Column name but still working
body: <p>When I connect to the server name using it's name SQL is showing red lines under the code and stating things like column invalid or object invalid. But the code stills runs. When I connect to the server using it's IP I do not get the red lines and the code also runs. </p>
  
  <p>Can I trust the data when using the name? Also why is it doing this?</p>
  
  <p>I am using SSMS 2012 to access a brand new 2012 server.</p>