Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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.

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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