Last synchronisation date for a (merge)-publication

Hi!
Is there any table where I can find the last updated (last synced) date
and time for a subscription?
I am trying to warn a user if his/her subscription did not synchronise
since an xxx number of days but I can't locate the date/time for the
last successfull synchronisation.
Thx,
Ferry
you can query the history tables in the distribution database.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Ferry" <ferryswi A@.T ferryswi D.O.T tmfweb D.O.T nl> wrote in message
news:mn.a56e7d63bfca7a9f.23024@.TferryswiD.O.Ttmfwe bD.O.Tnl...
> Hi!
> Is there any table where I can find the last updated (last synced) date
> and time for a subscription?
> I am trying to warn a user if his/her subscription did not synchronise
> since an xxx number of days but I can't locate the date/time for the last
> successfull synchronisation.
> Thx,
> Ferry
>