info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



Microsoft SQL Server Replication Monitor Queries
by BF (Principal Consultant; Architecture; Engineering)
2016-03-18








Solution:



Create Procedure dbo.Replication_ReplicationMonitorQueries_ResCloud
as

exec [distribution].sys.sp_replmonitorhelppublication
@publisher = N'CLUSTER01',
@publisher_db = N'ResDB',
@publication = N'PubResDBResDB',
@refreshpolicy = N'0'

exec [distribution].sys.sp_replmonitorhelpsubscription
@publisher = N'CLUSTER01',
@publisher_db = N'ResDB',
@publication = N'PubResDBResDB',
@mode = 0,
@exclude_anonymous = 0,
@refreshpolicy = N'0'