xml out help

  • 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

  • This was removed by the editor as SPAM

  • Same problem.

    FOR XML EXPLICIT statemets inserts CR after 2033 character and I cannot find out any way to control it.

     

    _____________
    Code for TallyGenerator

  • 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

  • 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.

  • 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