commands in the msrepl_commands table

How long do records stay in this table? Is there a way to adjust the
setting?
SQL2K SP3
TIA, ChrisR
for named subscriptions they stay there by default less than 10 minutes
after they are applied on the subscriber - or whatever your transaction
retention is ( by default 0). (you can set this by right clicking on
replication monitor and selecting distributor properties. Its the at least
section)
For anonymous subscriptions it stays at the at most section in the
distributor properties dialog box, or within 10 minutes after that - when
the distribution clean up agent runs.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <bla@.noemail.com> wrote in message
news:elBPKIkLFHA.2252@.TK2MSFTNGP15.phx.gbl...
> How long do records stay in this table? Is there a way to adjust the
> setting?
> --
> SQL2K SP3
> TIA, ChrisR
>
|||Thanks Hillary.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#NCDldkLFHA.1308@.TK2MSFTNGP15.phx.gbl...
> for named subscriptions they stay there by default less than 10 minutes
> after they are applied on the subscriber - or whatever your transaction
> retention is ( by default 0). (you can set this by right clicking on
> replication monitor and selecting distributor properties. Its the at least
> section)
> For anonymous subscriptions it stays at the at most section in the
> distributor properties dialog box, or within 10 minutes after that - when
> the distribution clean up agent runs.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <bla@.noemail.com> wrote in message
> news:elBPKIkLFHA.2252@.TK2MSFTNGP15.phx.gbl...
>