info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



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'