linked server

Hi,
I met a problem in linked server is that I have 2 sql servers A & B, I
create linked servers from A to B and from B to A. When accessing in A, I
can retrieve records from B through linked server, but when reverse, cannot
access.
The error returned is just like that the query is looking for the object in
the current server, not from the linked server.
Any idea ?Hi,
Did you check your name resolution within A and B servers. It sounds to me
like login issue,
Andreas
"garfield cat" wrote:

> Hi,
> I met a problem in linked server is that I have 2 sql servers A & B, I
> create linked servers from A to B and from B to A. When accessing in A, I
> can retrieve records from B through linked server, but when reverse, canno
t
> access.
> The error returned is just like that the query is looking for the object i
n
> the current server, not from the linked server.
> Any idea ?
>
>