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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 I lose rows with Trans Repl

Author  Topic 

kyklovod
Starting Member

4 Posts

Posted - 2002-07-17 : 07:29:11
I have configure Transatonal Replication.My network is not very good and i have some periods of fails connection between these two servers.Sometimes i recieves error for network sometimes i not ...But this is not the problem.The problem is that i lose rows at subscriber the statement but with no errors in replication agents
select count(*) from published_table_at_publisher returns different values than
select count(*) from published_table_at_subscriber
but transactiona replication continue with no error ... I recieve error "The row was not found at the Subscriber when applying the replicated command." after some one try to update that rows that are not in table_at_subscriber

do u have any ideas ?what is such a behaviour?

   

- Advertisement -