Blank value inserted into untyped XML column in replicated table kills Log Reader agent - by Kendal Van Dyke

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<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 588723 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 8/24/2010 9:07:14 AM
Access Restriction Public


SQL Server allows a blank value\emptry string ('') to be inserted into an untyped XML column. If the column is in a table that is part of a transactional replication publication the blank value will cause the Log Reader agent to fail. This happens on all versions of SQL Server since 2005 RTM.
Sign in to post a comment.
Posted by Maria Zakourdaev on 5/25/2013 at 2:49 AM
I experience this issue over and over in the sql 2008 R2. Was it fixed in sql 2012 ?
Posted by Jean-Yves [MSFT] on 12/3/2010 at 10:25 AM
Hi Kendal,

This issue does not repro in the early builds of next major release of SQL Server.

If you need more focus on this for existing versions of SQL Server I would recommend you contact our support staff.

You may already have a local support representative. If not you'll find more information on

Best regards
Jean-Yves Devant
Program Manager (Replication/CDC/CT)
SQL Server Engine Team
Posted by Jean-Yves [MSFT] on 10/29/2010 at 4:15 PM
Hi Kendal ,
thanks for taking the time to share your feedback, this is really important to us.
We will investigate the issue and get back to you.

Best regards
Jean-Yves Devant
Program Manager (Replication/CDC/CT)

SQL Server Engine Team