Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidD
Yak Posting Veteran
73 Posts |
 Posted - 2009-05-04 : 23:22:29
|
| Dear all, I am trying to find replication metadata tables that I can use to report on. Specifically I want histories of users and their synchronization times so that I can generate reports like thisUser Week1 Week2 Week3Fred 2:06 7:01 1:21Bill 6:34 3:57 2:00 If anyone can point me to the tables and views that I can use that would ge greatRegardsDavid |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-05-05 : 10:46:14
|
| Synchronization is done at the transaction level not at the user level. I dont think there is a way to find what you are looking for.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2009-05-08 : 01:59:59
|
| Hi Dinakar, Thanks for the reply. I think there must be that information available because it is displayed in the replication monitor (ie the subscriber name and the time of the last synchronization). I just need this information in a table form with it's history so that I can query it... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-09 : 23:39:03
|
| You will have to dig in here:http://technet.microsoft.com/en-us/library/ms179855.aspx |
|
|
|
|
|
|
Replication metadata