Re: copying data from one server to another

One way to work around the issue is to create a staging table on the remote

server. The table will not have IDENTITY column, so you can transfer the 
data. Then have a stored procedure to transfer between the staging table
and 
the production table. Inside the stored procedure you can set 
IDENTITY_INSERT ON and complete the insert.

HTH,

Plamen Ratchev
http://www.SQLStudio.com