Friday, March 23, 2012

Last time synchronized

I use SQLCE2.0 and merge replication.

Is there a way to query SQLCE to find the time of the last synchronization without manually tracking the time myself.

Thank you.

The following query works with SQL Mobile 2005 and later:

SELECT LastSuccessfulSync FROM __sysMergeSubscriptions WHERE Publication = " + strPublicationName

- not sure it works with SQL CE 2.0, though.

No comments:

Post a Comment