Post reply

Replication metadata

  • May 11, 2009 at 10:56 pm

    #204777

    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 this

    User Week1 Week2 Week3

    Fred 2:06 7:01 1:21

    Bill 6:34 3:57 2:00

    If anyone can point me to the tables and views that I can use that would be great

    Thanks in advance

    David

  • May 12, 2009 at 7:19 am

    #992866

    Check the MSDistribution_status view in the distributor. Maybe that will give an idea where you have to look.

    -Roy

  • May 12, 2009 at 4:54 pm

    #993343

    Hi Roy,

    Thanks for the reply. One problem - how to I edit (or view) a system view in 2005?

    Selecting from that view returns no records.

    Regards

    David

  • May 13, 2009 at 1:55 am

    #993489

    Editing would be a very bad idea.

    http://www.replicationanswers.com/Transactional.asp

    Here it gives some details about how to use that view and some stored procs that can be used.

    -Roy

  • May 14, 2009 at 8:30 am

    #994579

    SQL Server replication does not keep any information regarding users so you won't find what you are looking for unfortunately.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply