Re: How to Setup Linked Server
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/23/04
- Next message: Sue Hoegemeier: "Re: Security Admin and Backup"
- Previous message: Alan Tang: "How to Setup Linked Server"
- In reply to: Alan Tang: "How to Setup Linked Server"
- Next in thread: Hari Prasad: "Re: How to Setup Linked Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 22 Aug 2004 22:11:42 -0400
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!
- Next message: Sue Hoegemeier: "Re: Security Admin and Backup"
- Previous message: Alan Tang: "How to Setup Linked Server"
- In reply to: Alan Tang: "How to Setup Linked Server"
- Next in thread: Hari Prasad: "Re: How to Setup Linked Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|