SQL Server Developer >> Should I use linked server?
Hi there,
I have 2 mssql2k databases, on 2 seperate servers, linked together via a
network card.
I have an application on server 1 which uses data from server2 that
(currently) uses a different odbc to connect (with username and password).
Will I gain any speed by linking servers through "Linked Server" option?
SQL Server Developer >> Should I use linked server?
You probably will not get an increase in performace,
however you will be able to run distributed queries, and a
bit easier admin.
J
>-----Original Message-----
>Hi there,
>
>I have 2 mssql2k databases, on 2 seperate servers, linked
together via a
>network card.
>I have an application on server 1 which uses data from
server2 that
>(currently) uses a different odbc to connect (with
username and password).
>
>Will I gain any speed by linking servers through "Linked
Server" option?
>
>Thanks!
>
>
>.
>