Sorry Sergey:

No, no duplicate data on the primary server.

The data on the primary database (server machine 1) is exported to the secondary database (server machine 2).
Sometimes I forget to export newly created records to the secondary database. Sometimes, forgetting I'd skipped an export, I'll export the next batch. Both databases should exactly be the same. So, when I forget to export data, they become out of sync.

Just wanting to know if SQL Server can help me correct my stupid mistakes.

Mal

>Are you saying that you have duplicate data on the primary server?
>How do you import data on the secondary server?
>
>>Hi Surgey:
>>
>>Thanks for taking the time.
>>
>>I've been manually updating both primary and secondary server. Manually meaning transfering data from a cd and/or stick to each server. Sometimes, I forget to transfer to the secondary server and all of a sudden the servers aren't sync'd.
>>
>>What I did was delete all records of the specific table on the secondary server and import the entire records from the same table on the primary server.
>>
>>I there a way to import and instruct SQL Server to ignore duplicat data?
>>
>>TIA
>>
>>Mal
>>
>>
>>>Are you using DTS to update destination table or something else?