Creating Linked Server

Hello there
On my enterprise manager there are many Servers who are registered
I would like to transfare data between these two servers
When i'm conneted to one server on the query analyser and i'm trying to see
table from other server i get an error: Could not find server 'ROY-XP' in
sysservers. Execute sp_addlinkedserver to add the server to sysservers.
What i need to do in order to connect between these two servers?Roy
You can use EM to create linked server. Just provide a login and password
that can access the database.
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:eaj6jZa9FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hello there
> On my enterprise manager there are many Servers who are registered
> I would like to transfare data between these two servers
> When i'm conneted to one server on the query analyser and i'm trying to
> see table from other server i get an error: Could not find server 'ROY-XP'
> in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
> What i need to do in order to connect between these two servers?
>
>|||Hi,
sp_addlinkedserver -- map server with this
and
sp_addlinkedsrvlogin -- map user account with this
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Roy Goldhammer" wrote:

> Hello there
> On my enterprise manager there are many Servers who are registered
> I would like to transfare data between these two servers
> When i'm conneted to one server on the query analyser and i'm trying to se
e
> table from other server i get an error: Could not find server 'ROY-XP' in
> sysservers. Execute sp_addlinkedserver to add the server to sysservers.
> What i need to do in order to connect between these two servers?
>
>