Transactions done twice during failover

I suspect you need to put a pk on the Sybase tables to prevent this from
happening. If it is happening on the log reader agent writing to the
distribution database this is a known issue. When I encounter this I delete
the offending rows from msrepl_transactions and msrepl_Commands and have the
log reader send them again.

You might also want to use the continue on data consistency error profile.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Avi" wrote in message news:ecrj6c$hth$1@news2.netvision.net.il...
> Hi experts,
>
> I'm running replication from SQL Server 2000 to Sybase. Whenever I do a
> failover from one node to the other I get duplicate rows. That means that
> certain transactions are done twice.
>
> What can I do to avoid that?
>
> Thanks a million,
> Avi
>
>