msrepl_transactions

Hassan,
if you have anonymous subscribers or if not all of your
subscribers have synchronized, the commands will stay
there until the cleanup agent runs and the retention
period is reached.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
I have SQL subscribers .. How do I know if they are setup as anonymous ?
Also all my subscribers are uptodate and why do these tables have
commands/transactions in them that are 2 days old . Its definitely cleaning
up cos today when i looked, the min entry_time has increased since yesterday
but still around 52 hrs behind. This behaviour is only on one distributor..
The other is fine and deletes data that has been subscribed
Please advice..
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:170101c4e8d4$919bbcb0$a501280a@.phx.gbl...
> Hassan,
> if you have anonymous subscribers or if not all of your
> subscribers have synchronized, the commands will stay
> there until the cleanup agent runs and the retention
> period is reached.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||sp_helpsubscription will return the subscription type to
determine if it is anonymous.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql