Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determining last replication date

Status
Not open for further replies.
JoeAtWork

JoeAtWork

Programmer
Jul 31, 2005
2,285
CA
My client has a database with a lot of replicated tables. I strongly suspect they no longer replicate, that it is now just being used on its own as a single database. I'm trying to determine this for sure.

From some Google searches I've done, it appears that the history of replications is stored in the MSysExchangeLog table - can anyone confirm this?

Does the LastCommunication field tell me when a replication was last attempted?

And if the following fields all equal zero, can I assume no changes occurred to that database's data:
RowsUpdated
RowsDeleted
RowsInserted
RowsSent
TableCount
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
732
renigar
renigar
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
273
dhookom
dhookom
kmsohn
  • Locked
  • Question
Reservations prevent double booking on same date-Access
Replies
1
Views
164
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
Can't call procedure on Report... Working on detecting out of date objects for auto update
Replies
3
Views
181
lameid
lameid
digitalias
  • Locked
  • Question
Temporarily retain Date value in data entry form
Replies
0
Views
138
digitalias
digitalias

Part and Inventory Search

Sponsor

Back
Top