locked
Using FOR XML AUTO---limit on amount of data returned? RRS feed

  • Question

  • I am using the "FOR XML AUTO" clause on my SELECT statement and it appears that I am getting only 2033 characters of XML returned, which effectively is cutting it off and making it invalid.  I am using VS2008 for development and this is occurring in an ASP.NET code-behind file.

    Any ideas on what is happening here?

    Thanks!

    Jeff Tolman
    EandM Electric
    jeff.tolman@eandm.com
    Wednesday, March 17, 2010 7:03 PM

Answers