Yep, I am using SSMS. The setting is at max too. My problem is that this was working last week and returning the output to the xml_col without issue. I could then save the result as an xml file. This week, it does not work. The result is being truncated as you stated. Also, the text in the results are LOB files. They are essentially rtf documents.

I just cannot understand how it could work and now it does not. And, I am 100% sure that the data has not changed.