Hello, I am trying to setup a linked server between my
PROD and DEV server. On the DEV server, Using Enterprise
Manager, I try to create a link to the PROD server. I
specify the name, the impersonation user id and password,
etc and it appears to work (ie there are no errors). But
when I attempt a query it cannot find the object.
So I tried it the other way around; from PROD to DEV and
it works fine! DEV is a weekly copy of PROD.
I must be missing something but I can't figure out what it
is. Can anyone help?