Is it possible for a subscriber to know.......

whether it is sync...ing
is there any sp can find out the replication is working properly?
thank you very much
You could have a look at the distribution agent's job to see if it is in
process - sp_helpjob or this link:
http://www.replicationanswers.com/Do...unningJobs.txt
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)