I have a push transaction replication on SQL Server 2008 that has the Log Reader Agent trying to execute sp_MSadd_replcmds that blocks other commands, which has resulted in replication stopping. Each time I kill the process and restart the Log Reader Agent that same process blocks everything else.
When I view details on the Log Reader Agent through Replication Monitor the command count in 'Delivering replicated transactions, xact count:25, command count: 122701.' keeps getting higher and higher but no updates are made on the replicated database.
Can anyone give me suggestions or clues as to why this is happening and how I can go about fixing it? Thanks in advance!