locked
How I can add column to table on Subscriber ? This column exist on Publisher, but don't include in merge replication. RRS feed

  • Question

  • I use merge replication and I want add column to table on Subscriber, but when I tried run
    alter table ... add [object_id] int null
    I got

    "Msg 21531, Level 16, State 1, Procedure sp_MSmerge_altertable, Line 367
    The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a republishing hierarchy, DDL commands can only be executed at the root Publisher, not at any of the republishing Subscribers."

    How I can add column to table on Subscriber ? This column exist on Publisher, but don't include in merge replication.

    ashok nayak

    Friday, February 22, 2013 2:49 PM

Answers