Sample Header Ad - 728x90

How to find the records that are waiting to be replicated?

0 votes
1 answer
245 views
I had a look using the replication monitor and it is showing me commands that are awaiting to be replicated: enter image description here My question is - how do I find out what these commands are? I Have tried this query by Ben Anderson select @@Servername,a.publication + ':' + s.srvname as [Agent], v.undelivcmdsindistdb, v.delivcmdsindistdb, a.id from distribution.dbo.msdistribution_status v join distribution.dbo.msdistribution_agents a on v.agent_id = a.id join master.dbo.sysservers s on a.subscriber_id = s.srvid where v.undelivcmdsindistdb > 0 But the number does not exactly match, although it is definitely a good start, is there a way I can find more info about these records? enter image description here
Asked by Marcello Miorelli (17274 rep)
Dec 11, 2023, 10:48 AM
Last activity: May 7, 2024, 03:14 PM