Should I use linked server?  
Author Message
Remav





PostPosted: Mon Dec 15 06:36:11 CST 2003 Top

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?

Thanks!

SQL Server176  
 
 
Julie





PostPosted: Mon Dec 15 06:36:11 CST 2003 Top

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!
>
>
>.
>