Table structure modification while Replicating

[djj55]

Hello, in SQL 2000 we are exploring using Replication for reporting. However my manager remembers hearing that if a table structure is modified that it breaks replication.

Does anyone have information about this? I would think as long as you are listing the columns to replicate from a given table, replication would continue.

Thanks
djj

 

[mrdenny]

The ALTER TABLE statement doesn't work on replicated tables. You can add a column to a replicated table within the Publication properties pages or by using the stored procedures directly.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog