info@techdevops.com | 437-991-3573 | Data Tier Services
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, ERP, Performance & Cloud



Microsoft SQL Server Replication Monitor Queries
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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'