Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1
The error description is 'Unspecified error'.
The issue is not strictly related to the size of the XML document but to its complex structure. A combination of the XML element's structure depth, the number and size of attributes, and the number of entities within attributes can cause this issue. However, the level of complexity that is required to reach this limit is usually found in XML documents that are several megabytes.
Note Beware of very large single string attributes that contain many XML
Article ID: 2782589 - Last Review: Jan 9, 2013 - Revision: 1