Tuesday, March 20, 2012

cannot delete duplicated records

the servers i have is like that:
SERV-A is publisher,
SERV-B is subscribor to SERV-A
SERV-C is subscribor to SERV-B
I have sqlserver which the database on it is configured as publisher and
subscribor at the same time, I have duplicate record in a specific table on
that server only(SERV-B), when i tried to delete these records it give the
following message "cannot insert dublicate keyrow in object
msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement has
been terminated".
why this message appear and how i can delete these records?
thanks in advance.
Samir R. Ibrahim
run the merge agent on the publisher and subscriber/publisher. After it has
completed check the conflict viewer on both the publisher and
publisher/subscriber.
Hopefully the problem row will be in one of these tables and you can delete
it there.
"Samir R. Ibrahim" <samir.ibrahim@.wilcopm.com> wrote in message
news:OvWvIw3KEHA.556@.TK2MSFTNGP10.phx.gbl...
> the servers i have is like that:
> SERV-A is publisher,
> SERV-B is subscribor to SERV-A
> SERV-C is subscribor to SERV-B
> I have sqlserver which the database on it is configured as publisher and
> subscribor at the same time, I have duplicate record in a specific table
on
> that server only(SERV-B), when i tried to delete these records it give the
> following message "cannot insert dublicate keyrow in object
> msmerge-tombstone with unique index ucimsmerge_tombstone" "the statement
has
> been terminated".
> why this message appear and how i can delete these records?
> thanks in advance.
> Samir R. Ibrahim
>
>

No comments:

Post a Comment