April 13, 2009 at 1:51 pm
Hello,
I have a requirement where I need to assemble an intermediate table, process it, and assemble a final product by joining the original table with the processed results.
The twist is that the processing of the intermediate table occurs on a different server. How do I get a table from Server 1 to Server 2?
+ SELECT INTO does not permit loading into a remote server.
+ INSERT ... SELECT INTO, same as above
+ Calling a Stored Procedure from the remote server to do a 'reverse SELECT INTO' does not seem to work either, since you can't call an SP remotely.
Any Suggestions?
thanks a bunch
April 13, 2009 at 2:43 pm
Try this,
1. create @temp table ( )
2. insert into @temp
select colunmlist from linkserver.dbname.dbo.tablename.
April 13, 2009 at 3:12 pm
Good thought. The INSERT INTO works, but how does one create the table on the remote server first?
April 13, 2009 at 3:28 pm
Found my answer. Needed set the 'RPC Out' on the Linked Server configuration to True, create a SP that will do the SELECT INTO on the remote Server. Call the SP remotely
Issue from SErver1 --> 'EXEC server2.database..SP'
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply