cannot delete dupliacted 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
>
> 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
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional

cannot delete dupliacted 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>
> 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
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
Eric Crdenas
SQL Server senior support professional

cannot delete dupliacted 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>
> 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
--
Hi Samir,
This information might help:
INF: Understanding Merge Replication Conflict Detection and Resolution
http://support.microsoft.com/?id=315514
Regards,
--
Eric Cárdenas
SQL Server senior support professional