Hi,

I have some problems in transactional replication.

Case 1:
When the subscriber goes offline mode, I add the same records in the both
size (distributor & subscriber).
After the subscriber onlines again, the error occurs.

Case 2:
When the subscriber goes offline mode, I delete the same records in the
both size (distributor & subscriber).
After the subscriber onlines again, the error occurs.

How to solve these cases? Thanks.

James

James - with plain transactional replication you are not supposed to alter
the data on the subscriber. If the subscriber is being used as a failover
database, then queued updating subscribers might be what you need so that
the subscriber is allowed to change the data, but their changes won't cause
errors?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

thx.


"Paul Ibison" <Paul.Ibison@Pygmalion.Com> ¼¶¼g©ó¶l¥ó·s»D:ObeOjL2HHHA.4992@TK2MSFTNGP04.phx.gbl...
[quoted text, click to view]