Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Jul 31, 2007 08:57 PM|LINK
I need to copy all of the rows in a table from a database on one server, to another existing table of the same name in a different database on a different server. I'm trying to use a SELECT INTO statement. Any idea how to do this?
SELECT * INTO DestinationServer.dbo.DestinationDB.DestinationTable
FROM SourceTable AS SourceTable_1
But this doesn't work, saying there are too many prefixes.
Any idea how to do this?