XML server memory is low

8 Jul 2005 9:12 AM

brendanjobs

Hi
I've been using openxml in a stored procedure for a couple of week
until a few days ago i get the message below.
My procedure has been using sp_xml_removedocument .
Does anyone have a solution to this problem without restart the server.
im using sqlserver 2000 standard SP3.
Is there a command i can use to clear the procedure buffer.
Would that fix my problem

"XML document could not be created because server memory is low. Use
sp_xml_removedocument to release XML documents"
Thanks

8 Jul 2005 10:52 AM

Tibor Karaszi

I heard somewhere that MS did some re-write for the XML internal representation in sp4. It might be
worth checking out the sp4 details to see if that might help you.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

<brendanj***@yahoo.co.uk> wrote in message

Show quote

news:1120813968.000215.172650@g49g2000cwa.googlegroups.com...
> Hi
> I've been using openxml in a stored procedure for a couple of week
> until a few days ago i get the message below.
> My procedure has been using sp_xml_removedocument .
> Does anyone have a solution to this problem without restart the server.
> im using sqlserver 2000 standard SP3.
> Is there a command i can use to clear the procedure buffer.
> Would that fix my problem
>
> "XML document could not be created because server memory is low. Use
> sp_xml_removedocument to release XML documents"
> Thanks
>