General information
Forum:
Microsoft SQL Server
Title:
Inserting from a table from another database
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only