This is the default behavior. Once you have made this change you can't go
"Mojo" <Mojo@discussions.microsoft.com> wrote in message
news:73D45C24-6410-41E0-80FD-6345DE88DA6F@microsoft.com...
> It doesn't seem to matter what I do in the GUI/Wizard...no changes I
attempt
> to make in article defaults are saved. The behavior of the database
doesn't
> change.
> --
> Mojo Jojo
>
>
> "Hilary Cotter" wrote:
>
> > If the None is gone it means that nothing will be replicated. This is an
> > inconsistency in the GUI/Wizard.
> >
> > --
> > 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 > > "Mojo" <Mojo@discussions.microsoft.com> wrote in message
> > news:F2F8C8CE-AA36-4957-BBA0-0B29F5CE6CEB@microsoft.com...
> > > Hello,
> > >
> > > We're running transactional replication with no trouble...except we
can't
> > > seem to change the article defaults. We are running SQL Server 2000,
SP3,
> > > Standard edition.
> > >
> > > We don't want data deleted on the subscribers when data is deleted on
the
> > > publisher. I follow directions in chapter 4 of Hilary Cotter's
book...type
> > > the string 'NONE' in the 'Replace DELETE...' box.
> > >
> > > I dropped the subscription before doing this. After saving Default
> > Articles
> > > Property, I exit it, go back in, and the 'NONE' string is gone.
> > >
> > > I do this with table articles and indexed view articles...same
results. I
> > > try to change a property on the 'Snapshot' tab, same thing. The change
> > > doesn't stick.
> > >
> > > Any ideas?
> > >
> > > Thanks...
> > > --
> > > Mojo Jojo
> >
> >
> >