tpatten
asked on
SQL Server returned column limit: osql utility
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???
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???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.