How to Setup Linked Server

Hello:
Would you mind to tell me how can I setup the Link
between 2 SQL server that both server have located in
their local domain?
Thanks a lot!Probably easiest to use Enterprise Manager for this purpose. Expand your
server, expand "Security", click on "Linked Servers", and click the new
icon. You can set up the link from that menu fairly easily.
You can also set up linked servers using the sp_addlinkedserver and
sp_addlinkedsrvlogin stored procedures, which you can find syntax for in
BOL.
"Alan Tang" <alantang@.netband.com.hk> wrote in message
news:3b4501c488b1$f0f19690$a301280a@.phx.gbl...
> Hello:
> Would you mind to tell me how can I setup the Link
> between 2 SQL server that both server have located in
> their local domain?
> Thanks a lot!|||Hi,
Please see the below article.
http://www.microsoft.com/India/msdn/articles/166.aspx
Thanks
Hari
MCDBA
"Alan Tang" <alantang@.netband.com.hk> wrote in message
news:3b4501c488b1$f0f19690$a301280a@.phx.gbl...
> Hello:
> Would you mind to tell me how can I setup the Link
> between 2 SQL server that both server have located in
> their local domain?
> Thanks a lot!