Groups | Blog | Home
all groups > sql server replication > september 2005 >

sql server replication : Article Defaults --> can't change


Mojo
9/6/2005 8:54:52 AM
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...
--
Hilary Cotter
9/6/2005 12:17:45 PM
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
[quoted text, click to view]

Mojo
9/6/2005 5:12:41 PM
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


[quoted text, click to view]
Hilary Cotter
9/7/2005 9:58:37 PM
This is the default behavior. Once you have made this change you can't go
back, unless you use sp_changearticle.

--
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
[quoted text, click to view]

AddThis Social Bookmark Button