List of synchs?

Which query gives me the no of synchs in Merge replication? If a user is
synchronizing 10 times I need the information of all the 10 synchs.
I am using the following query,
SELECT a.subscriber_db
,runstatus
,start_time
,end_time
,duration [Synch Duration]
FROM dbo.MSmerge_sessions s
LEFT OUTER JOIN MSmerge_agents a
ON a.id=s.agent_id
This query is not giving me consistent result. Every time I run this query
I get some of the records missing.
Can someone put some light?
This should work. Is it possible that there are no rows synchronized during
these missing syncs?
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
"Ravi Lobo" <RaviLobo@.discussions.microsoft.com> wrote in message
news:07DC40EB-9386-4A41-82B8-027D80FDA4F9@.microsoft.com...
> Which query gives me the no of synchs in Merge replication? If a user is
> synchronizing 10 times I need the information of all the 10 synchs.
> I am using the following query,
> SELECT a.subscriber_db
> ,runstatus
> ,start_time
> ,end_time
> ,duration [Synch Duration]
> FROM dbo.MSmerge_sessions s
> LEFT OUTER JOIN MSmerge_agents a
> ON a.id=s.agent_id
> This query is not giving me consistent result. Every time I run this
> query
> I get some of the records missing.
> Can someone put some light?
>

List of Merge Article

I know transactional replication keep all articles in sysarticle system
table. Is there any other table or views for merge articles.
TIA
Thanks ,
I found the table name sysmergearticles.
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%236KR54AxHHA.1484@.TK2MSFTNGP06.phx.gbl...
> I know transactional replication keep all articles in sysarticle system
> table. Is there any other table or views for merge articles.
> TIA
>
|||Also have a look at sp_MShelpmergearticles.
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
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%236KR54AxHHA.1484@.TK2MSFTNGP06.phx.gbl...
>I know transactional replication keep all articles in sysarticle system
> table. Is there any other table or views for merge articles.
> TIA
>