November 23, 2005 at 9:03 pm
hi
i am new to xml. i am converting a huge table to xml with xml out in mssql 2000, and after a couple of rows the line breaks occures in the middle of a tag is there any way i can contol when to go to a new row?
thanks in advance
November 28, 2005 at 8:00 am
This was removed by the editor as SPAM
January 15, 2006 at 3:57 pm
Same problem.
FOR XML EXPLICIT statemets inserts CR after 2033 character and I cannot find out any way to control it.
_____________
Code for TallyGenerator
January 22, 2006 at 4:21 pm
Any guess what settings can cause this problem and if it's possible to modify it?
It's not QA, and not bcp.
What could it be?
_____________
Code for TallyGenerator
January 23, 2006 at 8:49 am
Have you tried the command line utilities. ISQL has a -w parameter that is the maximum line width of the output, see what happens if you set it to something really big.
January 24, 2006 at 7:09 pm
Actually I used bcp to call SP. So, it was command line utility.
I ran the same SP from QA just to find what is causing the error.
And it returned 2 lines despite I have set parameter "Maximum characters per column" (it's -w when start from cmd) to 4096 and total number of charachters in XML file is less than 3000.
It's something inside of SQL Server, but cannot figure out what it is.
_____________
Code for TallyGenerator
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply