Hello,
is it possible to insert data from a table from another database (I mean running on another server) using the insert into MyTalbe select MyFields from MyTable2 syntax (where MyTable2 is a table in antother database running on another server) ?? Or is there any other way using Transact SQL (so no DTS) ??
Best Regards,
Hans
is it possible to insert data from a table from another database (I mean running on another server) using the insert into MyTalbe select MyFields from MyTable2 syntax (where MyTable2 is a table in antother database running on another server) ?? Or is there any other way using Transact SQL (so no DTS) ??
Best Regards,
Hans