vbnetcoder
asked on
OPENDATASOURCE
How would i use OPENDATASOURCE to insert the records from a table in one database table to an identically named table in another Sql server instance on another server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't know all the details yet but i was told we maybe not be able to use linked server
So is the info above sufficient?
ASKER
OLemo. Likely, i will check it out latter today.
#a41712687 is the answer, as far as we can tell. There is not much more to add to that.
ASKER
ty
SELECT *
FROM OPENDATASOURCE( ...)