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?