Replication Monitor in VB6

Hello,
I need to continuously monitor the status of a SQL Server 2000 Merge
Replication agent; I was originally hoping to use the SQL Merge ActiveX
control, but that appears to only give me a status when I'm starting and
stopping merge replication from the same VB program. What I need to do is
stop and start replication from Enterprise Manager, but monitor for any
problems with VB. Any ideas? I've can work around the problem by watching
a table for certain records (I forget offhand the name of the table in
distribution) but I'd rather do something a bit more event driven as opposed
to a polling solution like this.
Any help would be greatly appreciated! Thanks!
MBC
Microsoft implements a polling method for this. Basically you would want to
poll the MSdistribution_history and msrepl_errors tables in the distribution
database.
Hilary Cotter
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
"News" <mbcdev@.yahoo.com> wrote in message
news:AOGdnfu-7s9YeRzfRVn-pA@.wideopenwest.com...
> Hello,
> I need to continuously monitor the status of a SQL Server 2000 Merge
> Replication agent; I was originally hoping to use the SQL Merge ActiveX
> control, but that appears to only give me a status when I'm starting and
> stopping merge replication from the same VB program. What I need to do is
> stop and start replication from Enterprise Manager, but monitor for any
> problems with VB. Any ideas? I've can work around the problem by
watching
> a table for certain records (I forget offhand the name of the table in
> distribution) but I'd rather do something a bit more event driven as
opposed
> to a polling solution like this.
> Any help would be greatly appreciated! Thanks!
> MBC
>