I have a Transaction replication set up, it was running fine and started to given problems for one table only. When I add this table in replication distribution stops delivering transactions to subscriber when I remove it everything is running fine.
I have to use a Script to find hung transaction on distributor as monitor tool won't show me anything. Has any one faced this problem before ? Does any one was able to resolve this? I am still trying to find a solution for this.
Thanks for your help.