Is there a way to change the default setting in SQL Server replication? Example when I create an new article I want to have the create Non-Cluster set to true all the time.


there is no default server configuration setting to achive this task. Replication is article based and that can done after creating replication. you can add number of articles once by add dialog wizard and then enable property by "set properties of all table articles".

enter image description here

Make sure reinitialization of subscription is required after changing the property.


No you cannot change the default UI settings but you can create your publication and add articles via T-SQL script using sp_addarticle and set the appropriate @schema_option.

  • 1
    You can also try this: in the Articles dialog, open the Articles drop-down list, then select Set Properties of all table articles, and go ahead from there.
    – Lena Weber
    Oct 22 '13 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.