title: 'Violation of PRIMARY KEY constraint' SQL Error
body: <p>This seems to be a pretty common question that is asked but, everything I have tried so far has left with with no solution.  I am using an ID field for my PK and auto increment has been turned on.  This is occurring in a DEV environment where data has been merged with the current data.  </p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>I am using a SQL Server.  I have also ran DBCC CHECKIDENT([ceschema.ce_attendeeCredit]) and the identity seems to line up properly.  I think there may be a deeper issue in play.</p>
  
  <pre><code>INSERT INTO tblpersonCredit
                  (
                  personID,
                  CreditID,
                  Amount,
                  ReferenceNo,
                  CreatedBy
                  )
              VALUES
                  (
                  &lt;cfqueryparam value="#arguments.AttendeeCredit.getAttendeeID()#" CFSQLType="cf_sql_integer" /&gt;,
                  &lt;cfqueryparam value="#arguments.AttendeeCredit.getCreditID()#" CFSQLType="cf_sql_integer" /&gt;,
                  &lt;cfqueryparam value="#arguments.AttendeeCredit.getAmount()#" CFSQLType="cf_sql_float" null="#not len(arguments.AttendeeCredit.getAmount())#" /&gt;,
                  &lt;cfqueryparam value="#arguments.AttendeeCredit.getReferenceNo()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.AttendeeCredit.getReferenceNo())#" /&gt;,
                  &lt;cfqueryparam value="#arguments.AttendeeCredit.getCreatedBy()#" CFSQLType="cf_sql_integer" /&gt;
                  )
  </code></pre>