February 5, 2008 at 9:16 am
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
February 5, 2008 at 8:30 pm
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
February 14, 2008 at 8:04 am
Yes!!! Thanks for help.
🙂
May 7, 2014 at 11:54 pm
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply