I am running transactional replication om SQL 2005 SP4 x64 Std edition.
There are many publishers which has one subscriber, my distributor db is at publisher server.
All publications are out of sync as Distributor to subscriber history "No replicated transactions are available" where as I can see new data in table also new command are delivering to distributor as I can see in first tab publisher to distributor history. The strange part is there is no error or security or space issue but distributor is not working and saying No replicated transactions even undistributed command shows 0. If I re-initialize and run snapshot it goes to status = 3 sometimes too and I have to update status to 2 but even after that sync is not working. Please help it`ll be very big issue if I had to rebuild everything. I am stuck !