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.
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.
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.