MSSQL Server, error number: 2601

  • Ed7

    SSCrazy Eights

    Points: 8352

    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'

    go

    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.

    Thanks,

    TJ

  • Vivien Xing

    SSChampion

    Points: 12297

    Where did you get this error?

    Is this link related to your case?

    http://www.cryer.co.uk/brian/sqlserver/disagnt_cnidkriowui.htm

    BOL mentioned this error in details: http://technet.microsoft.com/en-us/library/ms151779.aspx

  • Ed7

    SSCrazy Eights

    Points: 8352

    Yes!!! Thanks for help.

    🙂

  • antonyrampling

    Valued Member

    Points: 52

    Have a problem with ACT?

    Email Ken Quigley at Keystroke - ken@keystroke.ca

    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