A duplicate value cannot be inserted into a unique index

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

I'll first give the caveat that I've been away from this project for many
weeks (but at least it is my own creation). Having said that, I'm not sure
if this is a replication problem or exactly what I have on my hands here.

When I submit an Insert to a particular table, I can submit as many Inserts
as I would like with no exceptions -- until I replicate my changes back to
the server, then download that table again. It would appear that I have
identical data in both the SQLCE table and the SQL2k table, but for a reason
that I have yet to figure out, the downloaded table will no longer accept
Inserts. I get the message: "A duplicate value cannot be inserted into a
unique index. [,,,,,].

I do not have indexes on any of the columns. I do have a primary key. Any
advice would be appreciated.
 
Apparently the main tables DO have indexes on the columns I was trying to
Insert into. Deleting the indexes and creating a new snapshot resolved the
issue. However, I believe the indexes should be there, just not as unique
indexes.
 
Nope. Identical values into unique indexed columns. I just dropped the
indexes for now.

ChrisR said:
It means you are trying to insert identical values into your PK.

Earl said:
I'll first give the caveat that I've been away from this project for many
weeks (but at least it is my own creation). Having said that, I'm not
sure if this is a replication problem or exactly what I have on my hands
here.

When I submit an Insert to a particular table, I can submit as many
Inserts as I would like with no exceptions -- until I replicate my
changes back to the server, then download that table again. It would
appear that I have identical data in both the SQLCE table and the SQL2k
table, but for a reason that I have yet to figure out, the downloaded
table will no longer accept Inserts. I get the message: "A duplicate
value cannot be inserted into a unique index. [,,,,,].

I do not have indexes on any of the columns. I do have a primary key. Any
advice would be appreciated.
Click to expand...
Click to expand...
 
Back
Top