Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



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'