Generate Snapshot

Hi to all,
How can I see the rate of snapshot Generation in my Merge Replication
(SQL 2005 SPK1)
You can query the table in the distribution database.
select datediff(Ss,min(start_time) , max(time)) from MSsnapshot_history
where agent_id=60
where agent_id is the merge agent you are interested in.
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
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1173955422.955851.314520@.o5g2000hsb.googlegro ups.com...
> Hi to all,
> How can I see the rate of snapshot Generation in my Merge Replication
> (SQL 2005 SPK1)
>