Re: Internals question

probably - sp_MSadd_repl_commands27hp

--
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:eEl1b$KrFHA.3812@xxxxxxxxxxxxxxxxxxxxxxx
> 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: Identity Range Management
    ... > if Automatic Identity Range Management is not working correctly. ... >> Looking for a SQL Server replication book? ... >> Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.replication)
  • Re: new index, catalog empty
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... But even after forcing a catalog rebuild and full population, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search for words in paths to a filename
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.inetserver.indexserver)
  • Re: Ignored words causing error
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Cant get AND to work.
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)