title: MS SQL Server 2008 Link server query says "Invalid Object Name" but still works
body: <p>The following query has a red squiggly underlining for the server through to the table this bit <code>[OtherServer].[UAT_DB].[dbo].[profileTable]</code> and when hovering says <code>Invalid Object Name</code>, but interestingly if I execute the line it returns the correct records from the linked server table:-</p>
  
  <pre><code>select * from [OtherServer].[UAT_DB].[dbo].[profileTable]
  </code></pre>