Post reply

Trying to suppress additional info when using ''for xml'' through stored proc

  • February 3, 2005 at 7:24 am

    #162475

    Greetings folks,

    I have created a sp comprising of a bunch of sql statements with 'for xml auto, elements' to get data from different sql tables and store the output in a file.

    The problem i face is that along with the xml tags and data also comes in the standard gibberesh

    Example:

    (1 rows(s) affected)

    XML_F52E2B61-18A1-11d1-B105-00805F49916B

    ------------------------------------------

    I want to suppress this sql notification from occuring . The reason is that I want to create a file based on xml tags data only that would be fed to a gateway comprising of strict schema.

    Is there some way I could specify in the sp to suppress this text.

    Thanks in advance,

    Rahul

  • February 4, 2005 at 12:28 am

    #540612

    Try setting this option, DBCC traceon(257)

    I have seen this in Google.

     

    Thanks,

    Ganesh

  • February 4, 2005 at 7:46 am

    #540681

    Thanks Ganesh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply