Linked server cannot see all of the rows in target server?

I was having trouble establishing a linked server, but thanks to some help I got on this forum the link is now working. The problem now is that I can't see all of the rows in the linked-server's tables. So if I run select count(*) from cmrez.dbo.reservations on the target server itself it returns 809472, but if I run the same query from a remote server I only get 78324. What's up with that!? EDIT - The linked server isn't working - it turns out that the source server also has a database/table called CMREZ.dbo.reservations, so that is what is being queried. So the linked server isn't linking correctly. It no longer gives me an error message when I try to query it, but it is fact not working. Any ideas why?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dave_Green ♦ commented · May 11, 2014 at 08:33 AM

How are you querying the linked server? 4 part name in the query (Server.database.schema.table)?

1 ·

Ben_G commented · May 12, 2014 at 03:06 PM

Yes - 4-part name.

0 ·

JohnM commented · May 12, 2014 at 03:19 PM

Does it give you any messages as at all?

0 ·

Ben_G commented · May 12, 2014 at 03:28 PM

Yes - I get "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.". I've found that I can get around this using a dedicated login that I specify with the linked server setup (which is not ideal - I'd rather use the default login using passthrough authentication).

0 ·