CDC may fail when assign a large size (more than 8000) value to the column

–by Liwei Yin, Microsoft SQL China Support Assume you have CDC enabled for a table with text/ntext column. 1 You moidfy the colum type from text/ntext to varchar(max)/nvarchar(max) 2 Then you do an update to the column thereon, tried to assign a large size (more than 8000)value to the column, the CDC may fail and
Read More »