"combfilter" <asdf@adsf.com> wrote in message
news:MPG.1ceea772c3c9bd2a98968a@news.newsreader.com...
> Shouldn't he publisher and the distribution db have the same tables
> marked for replication in both.
>
> On the publisher I run the following query to find out what is being
> replicated.
>
> use dce01
> select * from sysobjects where replinfo <>0
> the results are as follows:
>
> Areas
> Category
> CategoryItem
> Comp
> DayPart
> DayPartJobGroup
> dpvHstComp
> dpvHstDeposit
> dpvHstGndVoid
> dpvHstItemSales
> dpvHstLaborTotals
> dpvHstPromotion
> dpvHstSalesByInterval
> dpvHstSalesSummary
> dpvHstSalesTotals
> dpvHstShift
> dpvHstTender
> EmployeeByStore
> gblStore
> Item
> Promotion
> Region
> HstInventoryActivity <--- doesn't show up on dist. db
> HstPhysicalCountReporting <--- doesnt' show up on dist. db.
>
> I run this on dist. db.
> Select * from dbo.MSarticles where publisher_db = 'dce01'
> and here are the results from that. (missing 2 tables)
> Areas
> Category
> CategoryItem
> Comp
> DayPart
> DayPartJobGroup
> dpvHstComp
> dpvHstDeposit
> dpvHstGndVoid
> dpvHstItemSales
> dpvHstLaborTotals
> dpvHstPromotion
> dpvHstSalesByInterval
> dpvHstSalesSummary
> dpvHstSalesTotals
> dpvHstShift
> dpvHstTender
> EmployeeByStore
> gblStore
> Item
> Promotion
> Region
> missing ----->(HstInventoryActivity)
> missing ----->(HstPhysicalCountReporting)
>
>
> The subscriber is saying those two tables were being replicated and all
> the sudden stopped.
>
> I have ran a dbcc updateusage on the publisher with no luck. I even
> looked at the properties of every publication for this subscriber to see
> if i could find out what publication those tables were part of. No
> luck. I think the publisher is confused on what is actully being
> replicated.
>
> Any help would be appreciated.
>
> Thanks
> -comb
>

> are HstInventoryActivity and HstPhysicalCountReporting in sysarticles in the
> publication database?
>
>

"combfilter" <asdf@adsf.com> wrote in message
news:MPG.1cf2742cc9d2bd8298968d@news.newsreader.com...
> In article <OqRFyrCWFHA.1508@tk2msftngp13.phx.gbl>,
> hilary.cotter@gmail.com says...
> > are HstInventoryActivity and HstPhysicalCountReporting in sysarticles in
the
> > publication database?
> >
> >
> No they are not.
>
> -comb

> It doesn't sound like they are been replicated then. Do they show up in the
> publications?
>
>