|
Home > Archive > MS SQL Server Replication > January 2006 > Table for last synchronization time?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Table for last synchronization time?
|
|
| dbussert@gmail.com 2006-01-18, 3:23 am |
| I'm using SQL 2005 Standard and have a merge replication of 1 database
with 3 tables being sent to multiple computers. I would like to
display to the user in a web app when the last synchronization has
occured. I assume time of the last replication for the database and/or
tables is stored in a System Table, but I could find any columns that
looked like they had a numeric date. Does anyone know where I can find
this info?
| |
| Hilary Cotter 2006-01-18, 7:23 am |
| For push have a look at select time, publisher_db,srvname
from
MSmerge_history
join msmerge_agents on MSmerge_history. agent_id=msmerge_age
nts.id
join master.dbo.sysservers m on m. srvid=msmerge_agents
.publisher_id
on the publisher. For pull, do the same on the subscriber.
--
Hilary Cotter
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
<dbussert@gmail.com> wrote in message
news:1137564823.141835.233560@g14g2000cwa.googlegroups.com...
> I'm using SQL 2005 Standard and have a merge replication of 1 database
> with 3 tables being sent to multiple computers. I would like to
> display to the user in a web app when the last synchronization has
> occured. I assume time of the last replication for the database and/or
> tables is stored in a System Table, but I could find any columns that
> looked like they had a numeric date. Does anyone know where I can find
> this info?
>
| |
| dbussert@gmail.com 2006-01-20, 8:24 pm |
| thank you, I was able to find the info on the subscriber for pull. is
there no information stored at the publisher in pull mode at all?
|
|
|
|
|