Wednesday, 11 September 2013

MS SQL Server 2008 Link server query says "Invalid Object Name" but still works

MS SQL Server 2008 Link server query says "Invalid Object Name" but still
works

The following query has a red squiggly underlining for the server through
to the table this bit [OtherServer].[UAT_DB].[dbo].[profileTable] and when
hovering says Invalid Object Name, but interestingly if I execute the line
it returns the correct records from the linked server table:-
select * from [OtherServer].[UAT_DB].[dbo].[profileTable]

No comments:

Post a Comment