Primary Key Constraint Violation
Posted on 1998-07-30
In attempting a series of inserts into multiple tables, I am consistently experiencing a Primary key constraint violation - "Msg 2627, Level 14, State 1
Violation of PRIMARY KEY constraint 'aaaaatblInstitutions_PK': Attempt to insert duplicate key in object 'tblInstitutions'.
Command has been aborted." This database has been upsized from MS Access 97. The first time I attempt to insert into this table and the others that accompany this insert, it works fine. After the initial time, it begins to error. Note that we are not in any way writing explicitly to the primary key which has an identity key and a seed and increment of 1. The application that is writing to the db is Cold Fusion. There is a transaction around the set of inserts and select statements. It is interesting that the error also occurs when attempting an insert within SQL Enterprise Manager Query tools.