Re: copying data from one server to another

If you can set up a linked server the other way around (from your remote 
server to the local server), then executing the query on the remote server

will have no problems setting IDENTITY_INSERT ON. The option cannot be set

permanently and it has to be set in the same session as the INSERT 
statement.

Alternative is to use BCP or Bulk Insert to insert the data which have 
option to keep identity.

HTH,

Plamen Ratchev
http://www.SQLStudio.com