Incorrect documentation regarding CDC and text/ntext/image - by sab39

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774272 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/13/2012 11:05:14 AM
Access Restriction Public


There is incorrect documentation on this page:

That page states the following: "For the LOB data types varchar(max), nvarchar(max), varbinary(max), image, text, ntext, and xml, the old value will only appear in the update old row if the column actually changed during update. For other data types, the column value will always appear in both update rows."

However, this is incorrect. The correct information is given in a different page,, which correctly states: "Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column changed during the update. When __$operation = 1, these columns are assigned their value at the time of the delete. Computed columns that are included in a capture instance always have a value of NULL."

So, the original documentation is right about the var*(max) types, but wrongly states that the values are preserved for image, text and ntext when the values are changed, when in fact those are always assigned NULL. And I wouldn't want to even speculate, given this contradictory documentation, on what the actual behavior is of xml-typed columns.

See also this question which points out the correct docs (I commented about the incorrect ones there too).
Sign in to post a comment.
Posted by Microsoft on 1/8/2013 at 1:16 PM
Made the change you suggested. This will appear in a few weeks for SQL Server 2012 Books Online. Probably in a couple of months for SQL Server 2008 R2. Thank you.
Posted by Microsoft on 12/26/2012 at 8:32 AM
Thank you for submitting this. I'll look into it.