Lets say that I have a transaction which is open for a long time on a database where we have few tables replicated.
Will the rep-agent be able to transfer all the replication related inserts/updates etc. just before this oldest open transaction or will the rep-agent gets struck/wait till this open transaction completes ?
All the committed trans before the open trans will replicate at replicate side, but the trans after the open tran will not be replcated as there will be no commit for open tran in log. also all the trans committed, whose commit time falls after open tran, will also be not replicated.