Does increasing of a field size require disabling and enabling cdc for a table?

Question

I have to increase the size of a table field from 255 to 4000 chars. CDC is enabled for that table. Before I alter the column, should I disable cdc for the table or is the change picked-up automatically?

I read this link: https://msdn.microsoft.com/en-us/library/cc645937(v=sql.105).aspx, however, it is not clear from the Handling Changes to Source Tables what happens when the field size changes. Are the CT tables altered automatically?

Thanks!

score 1 · Answer 1 · answered Jun 23 '16 at 18:49

1

I tested this and the field size change is picked-up automatically!

answered Jun 23 '16 at 18:49

boggy

3,674
3
33
56

Does increasing of a field size require disabling and enabling cdc for a table?

1 Answers1