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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy