Query for Replication Status

Hi,
We have 50 databases in Merge Replication.
We want to know the replication status (replicating or failed) using query,
Any query is there to find out the status?
Please advise me.
Rgds,
Soura
Soura,
you could have a look at sp_MSenum_merge_subscriptions. It takes the last
value for a merge agent in MSmerge_history and looks at the runstatus value.
Alternatively, you could use my proc which works against job states directly
(http://www.replicationanswers.com/Do...unningJobs.txt). These
could be mapped to : -- 1 = Executing, 2 = Waiting For Thread, 3 = Between
Retries, 4 = Idle, 5 = Suspended, 6 = [obsolete], 7 =
PerformingCompletionActions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)