How to join a table in another SQL server

4 Aug 2006 1:38 AM

Anderson

Hi, all
Does anyone know how to join a table in another SQL server, thanks in
advance!

-ja

7 Aug 2006 1:03 PM

Tracy McKibben

Anderson wrote:

> Hi, all
> Does anyone know how to join a table in another SQL server, thanks in
> advance!
>
> -ja
>
>

Use a linked server. Books Online has more info

--
Tracy McKibben
MCDBA
http://www.realsqlguy.com