I am using a statement similar to this in an attempt to retrieve XML to a file:
EXEC master..xp_cmdshell 'osql -h-1 -w10000 -S ben -U todd -P todd -q "export_needs_xml" -o c:\test.xml'
In the stored procedure I am using XML EXPLICIT to create the XML. The problem is that the record returned is broken up into multiple rows, each roughly 2037 bytes.
When the data is written to an XML file, the XML is invalid because of the splits.
Is there a way that this can be modified???