"Kevin Lang" <KevinLang@discussions.microsoft.com> wrote in message
news:BB7EC7DF-A4F6-4ED5-BBA8-C3029CEB06C2@microsoft.com...
> Hi Jorge,
>
> In the Publication's "Articles" properties you can click on the "Article
> Defaults" tab (or change the properties for each article individually).
> There you can specify in the "Snapshot" tab, what should happen when the
> snapshot is applied. You can specify a variety of things. If you are not
> going to drop and re-create the target tables, you should specify how the
> data is to be deleted from the target tables before the snapshot is
applied.
> If you've got DRI defined on the target tables, you will not be able to
use
> the "delete all data from tables.." feature because it executes a
"truncate",
> which won't work if the table has logical "children".
>
> Essentially, all the commands to manipulate the schema at the subscriber
is
> contained in the snapshot.
>
> Cheers,
> Kevin
>
> "Jorge C" wrote:
>
> > Hi!
> > I'm new to SQL Server and replication but I need to setup a publisher
with
> > 10 subscribers using Transactional Replication.
> >
> > My initial problem: the initial snapshot is trying to drop my tables in
the
> > subscriber database and I don't want this to happen! (even because it
fails!
> > The schema is correct on all subscribers so I just want it to copy the
data,
> > nothing more!)
> >
> > How can I do this?
> >
> > Thanks for your help and attention.
> > Jorge C.
> >
> >
> >
> >

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:<Ora5mqCWFHA.3716@TK2MSFTNGP12.phx.gbl>...
> My understanding is that SQL Server will order the creation of objects
> according to dependencies and prevent this from happening.

> "Kevin Lang" <KevinLang@discussions.microsoft.com> wrote in message
> news:BB7EC7DF-A4F6-4ED5-BBA8-C3029CEB06C2@microsoft.com...
> > Hi Jorge,
> >
> > In the Publication's "Articles" properties you can click on the "Article
> > Defaults" tab (or change the properties for each article individually).
> > There you can specify in the "Snapshot" tab, what should happen when the
> > snapshot is applied. You can specify a variety of things. If you are not
> > going to drop and re-create the target tables, you should specify how the
> > data is to be deleted from the target tables before the snapshot is
> applied.
> > If you've got DRI defined on the target tables, you will not be able to
> use
> > the "delete all data from tables.." feature because it executes a
> "truncate",
> > which won't work if the table has logical "children".
> >
> > Essentially, all the commands to manipulate the schema at the subscriber
> is
> > contained in the snapshot.
> >
> > Cheers,
> > Kevin
> >
> > "Jorge C" wrote:
> >
> > > Hi!
> > > I'm new to SQL Server and replication but I need to setup a publisher
> with
> > > 10 subscribers using Transactional Replication.
> > >
> > > My initial problem: the initial snapshot is trying to drop my tables in
> the
> > > subscriber database and I don't want this to happen! (even because it
> fails!
> > > The schema is correct on all subscribers so I just want it to copy the
> data,
> > > nothing more!)
> > >
> > > How can I do this?
> > >
> > > Thanks for your help and attention.
> > > Jorge C.
> > >
> > >
> > >