Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mase2hot
Starting Member
36 Posts |
 Posted - 2012-07-09 : 17:19:38
|
| Hi,I get the error below. There seems to be a hotfix from MS but I'm not sure if I'm ok to run it. The hotfix says SQL Server 2008. I'm running SQL server 2008 R2, 10.50.1600.1. Link is http://support.microsoft.com/kb/975037Msg 548, Level 16, State 2, Line 1The insert failed. It conflicted with an identity range check constraint in database 'Debtsolv', replicated table 'dbo.Payment', column 'ID'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.The statement has been terminated.Msg 548, Level 16, State 2, Line 2The insert failed. It conflicted with an identity range check constraint in database 'TEST', replicated table 'dbo.Payment_Payout', column 'ID'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.The statement has been terminated. |
|
|
|
|
|
|
|
Merge Replication error on insert