How To Copy Tables Across Servers?

Hi,

We got a production database that gets
tables added to it daily.
So, every single day we transfer those new
tables via DTS to five (5) other servers (Each having the same
database name).

I found no way to use the 'select' stmt across servers.
Can we accomplish this daily transfer by using a
'Select' statement?

I'm not conversant with TSQL (yet!) and
would very much appreciate any help you can
give me.

Thank you very much


Mike






Subscribe: sql-general-subscribe (AT) yahoogroups (DOT) com
Unsubscribe: sql-general-unsubscribe (AT) yahoogroups (DOT) com
List owner: sql-general-owner (AT) yahoogroups (DOT) com
URL: http://groups.yahoo.com/group/sql-general
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/sql-general/

<*> To unsubscribe from this group, send an email to:
sql-general-unsubscribe (AT) yahoogroups (DOT) com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

What Server are you using?=20
Microsoft SQL Server, Oracle, ...?


-----Mensaje original-----
De: sql-general (AT) yahoogroups (DOT) com [mailto:sql-general (AT) yahoogroups (DOT) com] En nom=
bre de sqlny1
Enviado el: Mi=E9rcoles, 08 de Marzo de 2006 14:22 p.m.
Para: sql-general (AT) yahoogroups (DOT) com
Asunto: [sql-general] How To Copy Tables Across Servers?



"Notificaci=F3n Autom=E1tica:
Este mensaje ha sido recibido desde la Internet, no se garantiza la autenti=
cidad del remitente. "

How To Copy Tables Across Servers?

Hi,

We got a production database that gets=20
tables added to it daily.
So, every single day we transfer those new=20
tables via DTS to five (5) other servers (Each having the same=20
database name).

I found no way to use the 'select' stmt across servers.
Can we accomplish this daily transfer by using a=20
'Select' statement?

I'm not conversant with TSQL (yet!) and=20
would very much appreciate any help you can=20
give me.

Thank you very much


Mike






Subscribe: sql-general-subscribe (AT) yahoogroups (DOT) com=20
Unsubscribe: sql-general-unsubscribe (AT) yahoogroups (DOT) com=20
List owner: sql-general-owner (AT) yahoogroups (DOT) com=20
URL: http://groups.yahoo.com/group/sql-general=20
Yahoo! Groups Links



=20




" Notificaci=F3n Autom=E1tica:
Este mensaje y cualquier archivo que se adjunte contiene informaci=F3n priv=
ilegiada y confidencial. Es para uso exclusivo del destinatario. Si usted h=
a recibido esta comunicaci=F3n por error, por favor av=EDsenos inmediatamen=
te.
Automatic notification:=20
This e-mail and any file transmitted with it are confidential and may be le=
gally privileged. It is intended solely for the addressee and may not be di=
sclosed to or used by anyone other than the addressee. If you have received=
this e-mail by mistake , please advise the sender immediately"


Subscribe: sql-general-subscribe (AT) yahoogroups (DOT) com=20
Unsubscribe: sql-general-unsubscribe (AT) yahoogroups (DOT) com=20
List owner: sql-general-owner (AT) yahoogroups (DOT) com=20
URL: http://groups.yahoo.com/group/sql-general=20
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/sql-general/

<*> To unsubscribe from this group, send an email to:
sql-general-unsubscribe (AT) yahoogroups (DOT) com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
=20