What version of SQL Server? What service packs have been applied? It may be a bug but I've not encountered it before.
-Mike
>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?