I am not sure if Query Analyzer uses ODBC provider while retrieving
records. If that is the case, then ODBC adds <CR> after 2034 chars if I am
not mistaken. I saw some previous discussions regarding this matter. Also
the query analyzer will trim your output based on the size of the buffer you
have set in the options.
You should try explicitly using a SQLOLEDB provider through ADO to
retrieve the XML.
Let me further check this issues further and I will let you know.
This posting is provided "AS IS" with no warranties, and confers no rights.
Quote:> SQL query analyzer is placing a <CR> in the result window
> at character 2034. When you copy the XML and place it
> into an XML viewer the output is invalid because of the
> <CR>. If you remove it and place it into an XML viewer
> the output is valid and the transformation executes. I
> tried outputing the results to a file and the <CR> are
> still inserted. Any help would be greatly appreciated!!!