Me again.
Is there a query to copy the data in a table in a database
on one server, into a table on another server?
I know I can just do "Import", but we need to know how to
do the same process via a query.
Thanks!

Assuming you have created a linked server called OtherServer:

insert OtherServer.OtherDB.dbo.OtherTable
select
*
from
MyTable


--
Tom
--------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com.sql
..

"Kyra" <kfelisky (AT) hotmail (DOT) com> wrote

Me again.
Is there a query to copy the data in a table in a database
on one server, into a table on another server?
I know I can just do "Import", but we need to know how to
do the same process via a query.
Thanks!