Insert Into a Table Across Linked Server From SP Using Openquery

Question

I want to send data across from one server to another, I wish to improve my performance and wondered if OpenQuery is a good route to go down?

I tried to do something like this;

INSERT INTO OPENQUERY (SERVERNAME, '(SELECT Num1, Num2, Num3 FROM [DBName].[dbo].TableName)')
(Num1, Num2, Num3)
SELECT Num1, Num2, Num3
 FROM #Temp

However this returns the error

The provider indicates that conflicts occurred with other properties or requirements.

I don't understand this as the query does run fine and produce the required results without OpenQuery...

Could any of you advise me on this please?

AnandPhadke · Accepted Answer · 2012-11-05 11:18:01Z

1

try this:

INSERT INTO tablename 
SELECT * FROM OPENROWSET
    ('SQLOLEDB', 
     'Trusted_Connection=yes;Server=SERVERNAME','SELECT Num1, Num2, Num3 FROM [DBName].[dbo].TableName)')

answered Nov 5, 2012 at 11:18

AnandPhadke

13.5k5 gold badges28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert Into a Table Across Linked Server From SP Using Openquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related