Select Into across Linked Servers

#1

Hi. I'm trying to copy from one table to another across 2 different
servers with the following:

select *
into #Tmp_Hdr
from parsaleshdr
where businessday = '9/20/07'

select *
into [pdsqla01\pdsqla01].impact_exec.dbo.parsaleshdr
from #Tmp_Hdr

This gives me an error:
The object name 'pdsqla01\pdsqla01.impact_exec.dbo.' contains more
than the maximum number of prefixes. The maximum is 2.

Not really sure how to get around it. I was trying to use OpenQuery,
but that's really for selecting from, not into. How can I get around
this?

Thanks,
Jennifer

#2

Jennifer (J.Evans.1970 (AT) gmail (DOT) com) writes:

Quote:

Hi. I'm trying to copy from one table to another across 2 different
servers with the following:

select *
into #Tmp_Hdr
from parsaleshdr
where businessday = '9/20/07'

select *
into [pdsqla01\pdsqla01].impact_exec.dbo.parsaleshdr
from #Tmp_Hdr

This gives me an error:
The object name 'pdsqla01\pdsqla01.impact_exec.dbo.' contains more
than the maximum number of prefixes. The maximum is 2.

Not really sure how to get around it. I was trying to use OpenQuery,
but that's really for selecting from, not into. How can I get around
this?

You need to create the table on the remote server in advance.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Select Into across Linked Servers

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Select Into across Linked Servers - 09-27-2007 , 10:38 AM

Re: Select Into across Linked Servers - 09-28-2007 , 04:43 PM