Hello my followers in the previous post i started my new series in (SQL Server DMV Replication Monitoring) and i explained very interested point for any DBA WORKING on replication solutions How we can know the current status of our Publication and subscription is it Active , In Active by simple DMV depend on dynamic Query technique and on SQL Server cursor TECHNOLOGY .
Summary of the previous post:
1- Publication Status
2- Subscription Status
3- Send Email by the Current status
Replication in SQL Server Series
Today is will complete this series to be this part is part two and i will add 2 new point very helpful for our daily WORK :
- Replication information for the Complete setup.
- Find publication article.