Hi Guy,
Today, I found some tables weren't replicated, they were not synchronised,
and some other tables got replicated. The replication setup is correct. I
checked the replication from replication monitor, no error, very strange. We
use transaction replication. Can anybody guess the reason? Is there any way
to check if the transactions were replicated? e.g. which system tables can I
check? Thanks.

What do you see if you run sp_browsereplcmds or look at the view
MSdistribution_status?
Also, how were the tables added to the publication - if through script it
might be that they weren't added to the subscription (sp_addsubscription).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Thank you for reply. I checked the subscription, the table articles are
there. two days ago, they were fine. since then, no data were replicated. But
it is weird that not error occured. In subscriber, I have a job running every
5 minutes, and the duration of this job lasts 2 minutes. the job called a
stored procedure. I don't know if this job locks the table and make the data
lost or not. Is that possible to be happened? Thanks.

[quoted text, click to view]