Re: Internals question

Tech-Archive recommends: Fix windows errors by optimizing your registry

What actually generates the commands?

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OyXEzyKrFHA.904@xxxxxxxxxxxxxxxxxxxxxxx
> Yes, for named subscriptions this is correct. For anonymous they hang
> around
> till the end of your retention period.
>
> --
> 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
> "Bob Castleman" <nomail@here> wrote in message
> news:eLmggmKrFHA.2588@xxxxxxxxxxxxxxxxxxxxxxx
>> According to Hillary's book, the table MSRepl_commands contains the
> commands
>> necessary to sync between publishe and subscriber. In my test database,
> this
>> is currently empty. This leads me to assume that these entries are
>> deleted
>> as the subcribers are fully synched. Is this correct? Also, how are these
>> commands generated and placed into this table?
>>
>> Thanks,
>>
>> Bob Castleman
>> DBA Poseur
>>
>>
>
>


.

Relevant Pages

  • Re: replication transaction logs
    ... "Hilary Cotter" wrote: ... > However for named subscriptions these commands are removed every 10 minutes. ... >> How can I find the tables or files where the replication log is stored. ...
    (microsoft.public.sqlserver.replication)
  • Re: Internals question
    ... for named subscriptions this is correct. ... Looking for a SQL Server replication book? ... > commands generated and placed into this table? ...
    (microsoft.public.sqlserver.replication)
  • Re: replication transaction logs
    ... However for named subscriptions these commands are removed every 10 minutes. ... Looking for a SQL Server replication book? ... "Lina Manjarres" wrote in message ...
    (microsoft.public.sqlserver.replication)
  • Re: Internals question
    ... > What actually generates the commands? ... >> Looking for a SQL Server replication book? ... >> Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.replication)
  • Re: MSrepl_commands question
    ... Undistributed commands will not. ... Hilary Cotter ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)