Insert data from a table from antother database

[HanzieV]

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

 

[vbkris]

yes it is possible.

try OPENROWSET method...

Known is handfull, Unknown is worldfull

 

[JamesLean]

Set up a linked server and then use:

INSERT table1
SELECT * FROM server2.db2.dbo.table2

--James

 

[HanzieV]

Hi all,

thanks for the replies. The openrowset method is what I was looking for !

Greetz,
Hans