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'
|
|
|
|
|
|