MSSQL Server, error number: 2601

  • Ed7

    SSCrazy Eights

    Points: 8514

    I setup transaction replication between sql 2000 (Publisher and local distributor) and sql 2005 (Subscriber).

    The db replication was running fine until I implemented a small change on Publisher server.

    exec sp_changearticle 'KM_Data', 't_table1', 'del_cmd', 'NONE'


    I run the initial database snapshot and it was completed.

    Then, I got an error on:

    "Cannot insert duplicate key row in object'dbo.t_table2' with unique index 'aaa_t_table2_PK' (Source MSSQLServer, Error number: 2601)"

    Please help and advise.



  • Vivien Xing


    Points: 12297

    Where did you get this error?

    Is this link related to your case?

    BOL mentioned this error in details:

  • Ed7

    SSCrazy Eights

    Points: 8514

    Yes!!! Thanks for help.


  • antonyrampling

    Valued Member

    Points: 52

    Have a problem with ACT?

    Email Ken Quigley at Keystroke -

    He can fix anything!!

    I spent months trying to solve a synchronization problem.

    I searched everywhere and spent so many hours trying to fix it

    He had the solution in minutes

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply