I have a transactional replication set up and works fine. But the issue that I have is when I run dbcc opentran on publisher database I get a message stating an Old Replicated Transaction is still open.
I deleted the replication and set it up from scratch and found out it starts happening as soon as log reader picks up a transaction. During initialization and after initialization I did not see any open transaction.
Can any one tell me how this can be corrected. I've set up transactional replication on bigger tables before (On another assignment) and have never run into this. The problem with Open transaction is that log can potentailly start growing and I want to find the issue and fix it.
Thanks
Sreejith