alter operation

This effectively means that an ALTER operation cannot be used to drop a column on a table that contains an XML column.

Process DML log records generated due to an alter operation while moving the rows from the old partition to the new table partition.

Perform the alter operation at all the replicate participants.

To perform the above alter operation, first convert the classic replicate to a master replicate.

After completing the alter operation transaction, the server unsets the alter mode (if alter mode was set as part of the same transaction).

If you are performing an in-place alter operation or altering a read-only server, replay position advancement is not performed.

It needs enough space to perform the alter operation on the associated delete table, along with the alter operation on the replicated table.

After a slow alter operation, Enterprise Replication does not convert the table rows from the original to the new format.

Problem 4: An alter operation on a replicated table fails.

If a catalog with the specified name does not exist, Microsoft SQL Server returns an error and does not perform the ALTER operation.

For example, you avoid the need to advance the replay position for each alter operation.

On a replicated table, use alter mode to prepare Enterprise Replication for the alter operation