SqlServer Bug: The replicate_ddl parameter is invalid.

SqlServer Bug: The replicate_ddl parameter is invalid.

A bug was found in the latest architecture change tests for updatable subscriptions.

During replication, when the Publishing Database changes the architecture of the Publishing Database, the structure is automatically synchronized to the subscription (this is the replication architecture change ). For some reason, when adding a field to a table, you do not need to synchronize it to the subscription. In the release attribute, there is an option to control schema changes that are not synchronized. For example:

OnlyCopy schema changesThe value is changedFalse, Change the structure is not synchronized, the change takes effect in real time.

You can also modify the parameter as follows:

EXEC sp_changepublication @ publication = n'publication ', @ property = n' replicate _ ddls', @ value = 0 GOEXEC sp_changepublication @ publication = n' publication ', @ property = n' replicate _ ddl ', @ value = 1GO

However This parameter is incorrect in Microsoft SQL Server 2008 R2 (RTM. When you change the parameterFalseThe architecture change will not be synchronized; but the parameter will be changed back.TrueThe structure changes are still not synchronized. If the problem is suspected to be a bug, the relevant documentation is not found to illustrate this problem, so download Microsoft SQL Server 2008 R2 Service Pack 3 and try again. After SP3 is installed, it is normal !~ Maybe this function is rarely used, and the problem and repair documentation are not found. Since sp3 has been fixed, it indicates that it has been officially fixed.