I got the answer. The BulkLoad had to be called on an Apartment Threaded object. I was initially trying to call it from a free threaded COM object....

Andy is correct. I have used the ADO Stream object and returned very large XML results. I have had no problems with extra carriage returns.

Phil Cleveland

From what I have read, to get the root node you must create it programmatically. SQL Server won't return it. So, you would create a string like this:...