Vertical Partitioning and New Columns

Question

Suppose you have an existing table and article for transational replication, and vertical partitioning is enabled.  There is a need to add a new column to the existing table, but the column does not need to be replicated.

a)  It seems that SQL Server will replicate the column by default, even if vertical partitioning is enabled.  Is that true?

b)  If so, is that behavior something that can be changed, so that new columns are not replicated automatically?

Thanks!

Jason

Answer 1

Correct, by default the newly added column will be replicated.

To add a new column to a table a not have it replicated, set publication property @replicate_ddl to 0, then add the column using ALTER TABLE <Table> ADD <Column> syntax.

---

Brandon Williams (blog | linkedin)