SQL XML Result

[Looch]

All,

I'm only getting half of an SQL XML result when I view the result in
my application. When I serialize the result to an xml file and view it
with notepad the first line begins in the middle of an element name
that is somewhere in the middle of the result set.

What might cause this?

I'm using 'for xml auto, elements, root ('root')' in my SQL query.

Thanks in advance

 

[Looch]

Playing around I got this to work:

for xml auto, elements, type, root ('root')

Strange.

 

[Mike Urquiola]

Typically this is due to using a stream based object (xmlTextWriter) and not
calling flush() or close() on it, since these objects have an internal
buffer.