Re: Monitoring & Starting Distribution Agent thru program

Tech-Archive recommends: Fix windows errors by optimizing your registry

Kumaresh,

how are you setting off the distribution agent? If it is through programming
the activeX control, you could then have a look at the replication errors
collection. This example applies to merge, but AFAIK it's much the same for
transactional.

http://www.windowsitpro.com/Files/09/39079/Listing_01.txt

Alternatively you could look at MSdistribution_history and MSrepl_errors
tables (or the job's history directly)

HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.