views:

454

answers:

1

Does anyone know the query the last synchronization date from sql server (2008).

It is the same information displayed in replication monitor, but I want to be able to get that date from a query.

+1  A: 

You can see a lot of info about merge sessions by using the system table msMerge_sessions:

select * from msMerge_sessions

Depending on the info you need, use the other system tables available in your database.

Philippe Grondier