This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C22136.2B9B8C00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Henry,
I tried it on my machines and I get the same error.
I think you are not allowed to "select into" from one server to 
another.
Your syntax is correct though and I know for a fact that it works well 
from
one database to another but on the same server.
Sorry I was not more helpful

CNB


-----Original Message-----
From: SD-Studios [mailto:info@s...]
Sent: Monday, July 01, 2002 1:16 PM
To: sql language
Subject: [sql_language] SV: 2 Servers running SQL Server


Isnt it suppose to be "INSERT INTO"?
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com


-----Ursprungligt meddelande-----
Fr=E5n: henryh@p... [mailto:henryh@p...]
Skickat: den 1 juli 2002 18:17
Till: sql language
=C4mne: [sql_language] 2 Servers running SQL Server


OK, here is my problem.

I have two servers running SQL server SQLa and SQLb.
I can do a simple select being logged into SQLa by a statement like 
this.
SELECT * FROM SQLb.database.dbo.table
When I try
SELECT * INTO SQLb.database.dbo.table
FROM datebase.dbo.table
It gives me a error saying too many prefixes.

Any idea why would be very helpful.

Thanks
Henry