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,
Avi

Can you put a PK on the Sybase tables and use the continue on data
consistency errors profile?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



[quoted text, click to view]