Very Computer

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?  

Thanks

Ric

Quote:> 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?

> Thanks

> Ric