>I have a simple table with 5 fields, 6 records and a primary key on the table. I'm using DTS to import some data - by mistake I imported the same data from VFP Tables to this particular SQL Server tables. DTS allowed the same records to be import without erroring out on the Primary Key Violation.
>
>So now I have record 1 through 6 twice listed on my primary key.
>
>Is this a bug??? Or a feature?

Is the key field configured as such in both SQL Server and VFP?