1) this setting means that existing data in the subscriber tables will remain there when you start a new snapshot and send it down. So if the table has 100 rows in in with the values of 1, 2, 3,...100, and you re-run a new snapshot it will attempt to add
these rows again.
This should persist. Check the schema option to ensure it does. Are there other publications which contain this aeticle?
2) You need to write the word NONE in for all of these statements. There were some bugs which caused this to not "stick" so you will need to use sp_changearticle and sp_helparticle to verify that the changes are persisted.
3) This is by design if you have set action name if in use to Keep Existing Object unchanged. I think you want to delete all the data to drop the table
4) Skip error only work after the snapshot is applied.
looking for a book on SQL Server 2008 Administration?
http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search?
http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
