Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Bangalore, India
    Posts
    27

    Red face Unanswered: Replication Automation...

    My Scenarion is like this.


    I have configured replication with a publication database, a distributor database and a few subscriber databases.
    The replication model is snapshot + transactional replciation.

    Now i want to check using system stored procedures as to whether the replication is configured and running properly.

    What are the system stored procedures which can be used and how do use them??

    Basically i wanted to automate the check of replciation. How can this be done?

    --Sandu.

  2. #2
    Join Date
    Jun 2003
    Location
    CA, USA
    Posts
    21

    Arrow

    Try MSdistribution_history table in he Distribution database. The "comments" and the "runstatus" columns will give you the status of your replication agents.

  3. #3
    Join Date
    Oct 2003
    Location
    Bangalore, India
    Posts
    27
    Originally posted by pushistik
    Try MSdistribution_history table in he Distribution database. The "comments" and the "runstatus" columns will give you the status of your replication agents.
    Is there any other tables or system stored procedures which i can check to see the replciation details???

    --Sandu.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •