locked
Snapshot replication does not copy default values in tables' fields RRS feed

  • Question

  • Hi,

    I have SQL 2008 R2 Standard in one side (Publisher)  and SQL 2008 R2 Express in the other (Suscriber), the publication is a push type, but the tables at the suscriber lost their default values. How can I fix that this?

    These are my publication option values:


    G.Waters



    Saturday, September 16, 2017 8:58 PM

Answers

  • If all of your changes originate on the publisher you should not have to worry about this as your default will be applied there.

    However you can set them in the article properties.

    • Marked as answer by George Waters Saturday, September 16, 2017 10:07 PM
    Saturday, September 16, 2017 9:56 PM
    Answerer

All replies

  • If all of your changes originate on the publisher you should not have to worry about this as your default will be applied there.

    However you can set them in the article properties.

    • Marked as answer by George Waters Saturday, September 16, 2017 10:07 PM
    Saturday, September 16, 2017 9:56 PM
    Answerer
  • Thanks buddy !!!

    G.Waters

    Saturday, September 16, 2017 10:08 PM