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?
>
>>
>>I have 2 locations each with a SQL Server machine. One machine is alwasy updated. I use EXPORT from the updated machine then IMPORT into the other machin to keep the machines the same. This has been working out, but recently I've been getting duplicate recrods. How do I implement an IMPORT and elimnate/ignore dulicate records. Is there a way to tell SQL Server's Import to ignore records already in the table?
>>