var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Undistributed transactions in published database SQL server 6.5
I have manually removed replication using Microsoft Article (Q170481)
"dbcc opentran (published_database_name) with table results"
The results showed the oldest distributed row ID and the oldest non-distributed row ID to differ.
I ran the following command
"sp_repldone 0, 0, NULL, 0, 0, 1" against the published_database_name to mark all replicated transactions as distributed.
I then ran
"dbcc opentran (published_database_name) with table results" again to check the results and found the 2 row ID's continue to differ.
The article advises to contact your primary support provider "If you continue to see replicated transactions in the transaction log.
Thanks in advance for any advice given