Re: what's the difference between Linked servers and Remote servers under EM/security?
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/02/04
- Next message: Sue Hoegemeier: "Re: backup to a network folder."
- Previous message: Lud: "delete tables"
- In reply to: == Steve Pdx==: "what's the difference between Linked servers and Remote servers under EM/security?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 02 Jun 2004 17:48:52 -0600
Remote servers are for backwards compatibility. You should
be using linked servers instead.
Both remote servers and linked servers add a row to
master..sysservers. The server name needs to be unique.
-Sue
On Wed, 2 Jun 2004 14:07:12 -0700, "== Steve Pdx=="
<lins@nospam.portptld.com> wrote:
>background sql2k, on NT5 box
>
>can someone educate me the difference (proper usage) of the two?
>One thing I noticed is that if there's a remote server named 'RemoteServerA'
>exists (just an example here),
>I couldn't create a linked server with the same name! Why??? and what's the
>workaround? it doesn't make much sense to name a linked server (or remote
>server) different from the target server you intend to reference to.
>
>thank you..
>
- Next message: Sue Hoegemeier: "Re: backup to a network folder."
- Previous message: Lud: "delete tables"
- In reply to: == Steve Pdx==: "what's the difference between Linked servers and Remote servers under EM/security?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
