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