servers

Using SQL 2000, we have been using the linked server functionality to
connect two databases that up till now have resided on two separate
servers. Our network people have now moved those databases so they are
on the same server. Can we continue to use Linked Servers to pass
queries back and forth? (I know we don't HAVE to, but I need to know if
we CAN.) Thanks.Yes you can, just remember that any access using a linked server will use a
new connection.
Loopback Linked Servers
http://www.databasejournal.com/feat...10894_1438991_4
AMB
"Rick Charnes" wrote:

> Using SQL 2000, we have been using the linked server functionality to
> connect two databases that up till now have resided on two separate
> servers. Our network people have now moved those databases so they are
> on the same server. Can we continue to use Linked Servers to pass
> queries back and forth? (I know we don't HAVE to, but I need to know if
> we CAN.) Thanks.
>