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
 
No comments:
Post a Comment