Posted by Erland Sommarskog on 09/28/07 21:43

Jennifer (J.Evans.1970@gmail.com) writes:
> 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@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: I want to parse @ArrayOfDays into @d1 through @d5
• Prev in forum: Re: Apparent DB engine bug in SQL Server 2005
• Thread view: Re: Select Into across Linked Servers

[Reply to this message]