>Hi:
>
>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?
>
>TIA
>
>Mal
Mal,
I'm not sure it's the right answer, but you can always add a check after your process is done and eiliminate duplicates.
If it's not broken, fix it until it is.
My Blog