"Bob Castleman" <nomail@here> wrote in message
news:eLmggmKrFHA.2588@tk2msftngp13.phx.gbl...
> 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
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:OyXEzyKrFHA.904@tk2msftngp13.phx.gbl...
> 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@tk2msftngp13.phx.gbl...
>> 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
>>
>>
>
>

"Bob Castleman" <nomail@here> wrote in message
news:eEl1b$KrFHA.3812@TK2MSFTNGP10.phx.gbl...
> What actually generates the commands?
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:OyXEzyKrFHA.904@tk2msftngp13.phx.gbl...
> > 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@tk2msftngp13.phx.gbl...
> >> 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
> >>
> >>
> >
> >
>
>