Microsoft SQL Server 2008 R2 XML处理 One solution is to increase the number of characters retrieved from the server for XML data.

在处理XML的时候，有时候数据库中的xml字符太大，读取会有问题，

TITLE: Microsoft SQL Server Management Studio
------------------------------

Unable to show XML. The following error happened:
Unexpected end of file while parsing Name has occurred. Line 1, position 2097154.

One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options.

------------------------------
BUTTONS:

OK
------------------------------

可以 在 工具---选项中设置，具体如图