Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    United Kingdom : Manchester
    Posts
    2

    Red face Unanswered: Replication : Deleted Records Keep Reapearing

    Im currently having problems with merge replication.

    Example:

    When a customer record is deleted from tbl_customers its removed from the table, then its reappears about 30s - 1min later?

    Im presuming the other server is restoring the record though replication.

    Any Insight in to this would be most appreciated.


    Daniel

  2. #2
    Join Date
    Apr 2003
    Location
    United Kingdom : Manchester
    Posts
    2

    Post Additional notes

    I've found the error but still not to sure why its occuring?

    Heres the errors
    -------------------

    "The row was deleted at 'ENTERPRISE.PMSPS' but could not be deleted at 'VOYAGER.PMSPS'. Invalid object name 'tbl_contacts'."


    [Conflict Winner]
    The error described above occurred when trying to delete this row. If you ignore this conflict, you should resolve it through other means. Consider logging the details of this conflict, then sending the log entry to your system administrator. The value of the unique ID in column 'rowguid' is '{D2604393-EBB4-4CF7-97BC-562C28B6BD1B}'.

    [Conflict Loser]
    This row has been deleted. If you choose to ignore the conflict, Microsoft SQL Server will try to reinsert the deleted row, using data from the other server.


    I have the option to Keep winning change which will just put the record back in or I can Resubmit the DELETE which just comes back with the same error.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •