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

Share this Post

–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 raise below error message:

You get below error message

Could not locate text information records for the column “Col1”, ID 2 during command construction.

The Log-Scan Process failed to construct a replicated command from log sequence number (LSN) {00000033:00000068:0013}. Back up the publication database and contact Customer Support Services.

Log Scan process failed in processing log records. Refer to previous errors in the current session to identify the cause and correct any associated problems.

Work around:

1 Remove CDC feature from all table with TEXT/NTEXT columns


3 Enable CDC again on these tables.

Reproduce steps, you can try below step in SQL Server 2014/2012

Share this Post

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.