At the time of doing a task its showing an Error: Cannot insert duplicate key row in object 'dbo.MSmerge_tombstone'with unique index'uc1MSmerge_tombstone'. Looking to hearing from you.
question is vague. which task? is it sql agent job? where are you creating it?
the error is explicit though you're trying to insert duplicate values to column containing unique constraint. so modify the insert statement to insert only distinct value for field
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
The task is Billing. It was going nice and smooth till yesterday afternoon. From the evening the problem begin to occur. We are using merge Replication with Push subscription. Any other info needed??
The task is Billing. It was going nice and smooth till yesterday afternoon. From the evening the problem begin to occur. We are using merge Replication with Push subscription. Any other info needed??
fazle rabbee
is insert done using a procedure? check the logic. it seems the relationship used between tables is not proper causing it to return duplicates
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Error at the time of doing a task
Posted - 08/11/2012 : 12:55:02
