I am on server1 which has a linked server to server2 and server3. This must be done on server1, but I can not get the syntax accurate.
What I want to do is query server2 using OPENQUERY, and insert the results of that query into a new table on server3.
I have tried the following, but no mustard:
SELECT * INTO LinkedServer3.dbName FROM OPENQUERY(LinkedServer2, 'Select * FROM empInfo')