"John" <jpappas@rd.com.SPAM_FREE_INBOX> wrote in message
news:05f201c3d952$677a7490$a301280a@phx.gbl...
> Thank you both for your help...So this is normal behavior
> and I shouldn't worry that they still exist?
>
>
> >-----Original Message-----
> >these objects are used when generating the snapshots. If
> your table is
> >large, or if your article on the publisher is different
> from the article on
> >the subscriber (horizontal or vertical partitioning - in
> other words a
> >different number of rows or columns), SQL Server chooses
> to replicate from
> >views (called sync objects) instead of the underlying
> base tables.
> >
> >This is what you are seeing.
> >
> >"John" <jpappas@rd.com.SPAM_FREE_INBOX> wrote in message
> >news:06af01c3d659$b2608810$a301280a@phx.gbl...
> >> Hello,
> >>
> >> I recently created several publications(for snapshot
> >> replication) along with subscriptions. The articles to
> be
> >> published were all views(over a hundred of them).
> >>
> >> I had to delete the publications/subscriptions and now I
> >> notice that there are hundreds of syncobj_* views(in
> place
> >> of the articles from replication I assume)in the
> database
> >> (named like this for ex: syncobj_0x3041463942373745).
> >>
> >> Does anyone know what purpose these serve? Do I need
> them
> >> even after I got rid of the publications?
> >>
> >> I'd appreciate any feedback.
> >>
> >> Thanks,
> >>
> >> John
> >
> >
> >.
> >