sp_xml_preparedocument failing for large xml documents

[Manish Garg]

I have a 2MB XML document which is passed to
sp_xml_preparedocument using a stored procedure.
It returns with a error --
"Not enough storage to complete this operation".

once I reduce the file size to less than 1 MB it works
fine.

Server has about 512 MB of RAM available.
Even if sp_xml_preparedocument uses only 1/8 of the total
memory allocated to SQL server, it is large enough to
parse a 2 MB file.

What could be the problem?

[Bryant Likes]

"Manish Garg" <manish...@hotmail.com> wrote in message
news:d1e401c1a543$437c5c60$9ee62ecf@tkmsftngxa05...
[snip]

> Server has about 512 MB of RAM available.

How much of that RAM is reserved for SQL Server?

--
Bryant

[Manish Garg]

>Looking at the SQL server properties on the Memory tab,
I found that the option "Dynamically configure SQL Server
memory" was selected.
Minimum (MB) = 0 MB
Maximum (MB) = 512 MB

>I also tried by selecting the option "Use a fixed memory
size" and setting it to about 300 MB. Still I got the same
error with the 2MB file

[Dan Doris [MS]]

The problem may be how large the XML document may expand once loaded. The
size may very greatly from what i've heard, in general you should consider a
4 to10 times size increase, in some cases larger depending on the structure
of your xml. If possible you may want to consider using bulkload if this
is an option for you.

Dan Doris
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and
confers no rights. You assume all risk for your use.
(c) 2002 Microsoft Corporation. All rights reserved.

"Manish Garg" <manish...@hotmail.com> wrote in message

news:d7a801c1a614$b0aeb180$9ee62ecf@tkmsftngxa05...