Copying Table From Local To Linked Server

Hi,

I'm trying to copy all the data from a single table across to a remote linked server and I'm having all sorts of problems.

The SQL query I'm attampting is this:-


Code:


EXEC sp_addlinkedserver 'GODZILLA', N'SQL Server'
EXEC sp_addlinkedsrvlogin 'GODZILLA', 'False', 'rmtUser', 'lclUser', 'password'
Go

--DELETE TABLE
DROP TABLE GODZILLA.Racing.dbo.horse

--SELECT INTO
SELECT horse_id, horse_filename, horse_time, horse_new, horse_driveLetter
INTO GODZILLA.Racing.dbo.horse

FROM Racing.dbo.horse

EXEC sp_droplinkedsrvlogin 'GODZILLA', 'lclUser'
EXEC sp_dropserver 'GODZILLA'




Basically - this doesn't work as an error is returned:-


Code:


The object name 'GODZILLA.Racing.dbo.' contains more than the maximum number of prefixes. The maximum is 2.



Now - it has no problem running a SELECT (ie read-only) query from the remote DB but why does it have a problem with writing? And if thats the issue, why doesn't it say so. Am I going about this the right way???

Please help!