Hello,

I have to import large ammounts of XML data into a SQL server database. However when I send a small XML document (just 15 kb) I'm running out of memory. It works if I make the XML document even smaller, but I will have to import XML documents of several megabytes. I'm using a stored procedure which uses sp_xml_preparedocument.
Has anyone experience with this kind of data import?

TIA

Martin