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.Try MSdistribution_history table in he Distribution database. The "comments" and the "runstatus" columns will give you the status of your replication agents.|||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.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment