SQL Server 2005 Replication Error RRS feed

All replies

  • Check the schema of the tbl_name on the server as well as on the subscriber machine. This usually happens when the schemas are not matching on both sides

    Prashanth Podduturi

    • Proposed as answer by Poddu Friday, May 4, 2012 7:53 PM
    Friday, May 4, 2012 7:50 PM
  • The Schema at both end (publisher and subscriber) is the same. What else could it be?  other error if it could help

    Violation of PRIMARY KEY constraint 'PK_table_name'. Cannot insert duplicate key in object 'dbo.table_name'. (Source: MSSQLServer, Error number: 2627)

    Thanks in advance


    Friday, May 4, 2012 8:37 PM
  • Hi

    try to reinitialize your subscriber....this happens when the schema is not identical between the publisher and the subscribe

    Saturday, May 5, 2012 1:54 AM