Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MSSQL Server, error number: 2601 Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2008 9:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:22 PM
Points: 354, Visits: 915
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
Post #451707
Posted Tuesday, February 5, 2008 8:30 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,279, Visits: 2,203
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

Post #451980
Posted Thursday, February 14, 2008 8:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:22 PM
Points: 354, Visits: 915
Yes!!! Thanks for help.

:)
Post #455716
Posted Wednesday, May 7, 2014 11:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 11:53 PM
Points: 2, Visits: 0


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
Post #1568768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse