• Hello,

    I am getting the same error "No replicated transactions are available". I am getting in the Log reader agent. When I run the command SELECT SUM(rows) FROM sys.partitions WHERE object_id = OBJECT_ID('msrepl_commands'); I got 5915 rows.

    The snapshot agent is running fine and is showing as 100% A snapshot for 45 articles was generated

    My publisher and distributer are on same machine and subscriber is on different machine. I am using Pull subscription.

    Please help me, I have to resolve the issue urgently.

    Thanks a Lot