Hello,
I'd like to be able to poll a SQL 2000 subscriber database to obtain the current replication status. For example, I'd like to know when the subscriber is sitting idle (e.g. "waiting for changes..."), when it is actively replicating (e.g. "applying script..."), or when it is in an error state (e.g. "The Merge Agent failed...").
I realize I can query the table MSmerge_history which contain a comments and error_id field that may be useful. However, there is no status field that I could easily code against.
Does anyone have any ideas

SQL 2000 Replication Status Question
mattdawg
hi,
regards,
joey
Casper.ptrsn