Article ID: 310378 - View products that this article applies to.
This article was previously published under Q310378
This article refers to the following Microsoft .NET Framework Class Library namespace:
When you read Extensible Markup Language (XML) data from Microsoft SQL Server by using the SqlDataReader object, the XML in the first column of the first row is truncated at 2,033 characters. You expect all of the contents of the XML data to be contained in a single row and column.
This behavior occurs because, for XML results greater than 2,033 characters in length, SQL Server returns the XML in multiple rows of 2,033 characters each.
To resolve this problem, use the ExecuteXmlReader method to read FOR XML queries. For additional information about how to use ExecuteXmlReader with SQL Server FOR XML queries, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/316016/ )How to use the ExecuteXmlReader method of the SqlCommand class in Visual Basic .NET
(http://support.microsoft.com/kb/316701/ )How to use the ExecuteXmlReader method of the SqlCommand class in Visual C# .NET
(http://support.microsoft.com/kb/307224/ )How to use XML in connected and disconnected ADO.NET applications
Steps to reproduce the problem
Article ID: 310378 - Last Review: March 13, 2006 - Revision: 2.1
Contact us for more help
Connect with Answer Desk for expert help.