Check Replication logs status/count
Search
Check Replication logs status/count
use ClubspeedV8
SELECT CAST( GETDATE() AS Datetime ) as 'Date & Time this script was ran'
go
SELECT COUNT(Deleted) as TriggerLogs
FROM TriggerLogs
where Deleted=0
go
Select COUNT(Deleted) as TriggerMemberships
FROM TriggerMemberships
where deleted=0
go
Select COUNT(Deleted) as FailedReplicationLogs
FROM ReplicateFailed
where Deleted=0
go
Select COUNT(Deleted) as FailedReplicationMembershipLogs
From ReplicateMembershipsFailed
where deleted=0
go