sql server replication: Last synchronisation date for a (merge)-publication -- sql server replication

Re: Last synchronisation date for a (merge)-publication

Hilary Cotter
3/20/2006 8:49:34 PM

sql server replication: 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

[quoted text, click to view]

Last synchronisation date for a (merge)-publication

Ferry
3/20/2006 11:10:31 PM

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