Re: copying data from one server to another

On May 15, 8:01 pm, "Plamen Ratchev" <Pla...@[EMAIL PROTECTED]
> wrote:
> 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 Ratchevhttp://www.SQLStudio.com


Ok, thanks for all. Regards.