Re: if replication failed half way
- From: "Narayana Vyas Kondreddi" <answer_me@xxxxxxxxxxx>
- Date: Thu, 26 May 2005 10:47:58 +0100
What sort of replication are you using? If all your child rows are inserted
in the same transaction then either all of them will be applied on the
subscriber or none.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"MarinaEe" <MarinaEe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E403B87B-1BA5-43EE-B241-FE9B15F79781@xxxxxxxxxxxxxxxx
i am having 1 header table and 1 child table, there is currently no column
to
store the number of children relation to 1 header. after replication, the
replicated records are to be processed by another program. the problem
happen when replication failed half way (due to line drop for instance),
only
some children records replicated successfully, whilst the other program is
unable to check, and will proceed with processing. is there anyway to set
SQL Server to rollback the replicated records if failed, or any other better
way to control this, to make sure the process is done only when all children
records are replicated?
.
- Follow-Ups:
- Re: if replication failed half way
- From: MarinaEe
- Re: if replication failed half way
- References:
- if replication failed half way
- From: MarinaEe
- if replication failed half way
- Prev by Date: Replication scenario. Heavy usage and limited bandwidth
- Next by Date: Re: Transactioanal replication
- Previous by thread: if replication failed half way
- Next by thread: Re: if replication failed half way
- Index(es):
Relevant Pages
|
