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:
316016 (http://support.microsoft.com/kb/316016/ ) How to use the ExecuteXmlReader method of the SqlCommand class in Visual Basic .NET
316701 (http://support.microsoft.com/kb/316701/ ) How to use the ExecuteXmlReader method of the SqlCommand class in Visual C# .NET
307224 (http://support.microsoft.com/kb/307224/ ) How to use XML in connected and disconnected ADO.NET application
or: Use SqlDataReader an iterate through all the lines.