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?
>
>

Creating link via Internet

Hello there
I have local sql server database on my server
I have also another sql database on my internet
I would like to transfare data from my local server to the internet server
at 12:00 pm every day
How can i create kink to the database on the server?
A few ways:
1. SQL Replication.
2. SQL DTS job
3. SQL Agent Scheduled Job
See SQL Books on Line. All three of these options are covered in depth.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.