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