sp_xml_removedocument doesn't work

[Shaun]

So sp_xml_removedocument returns failure constantly. Where can i submit a
bug? MS should have this fixed by now.

Also after about 300 files i get this error:

Server: Msg 6624, Level 16, State 1, Procedure sp_xml_preparedocument, Line
98
XML document could not be created because server memory is low. Use
sp_xml_removedocument to release XML documents.

And i've been attempting to release the documents using the same document
handle of course, it's not that convoluted - anyone else having this
problem?? Anyway around it?

Currently we are stopping and starting the server eveyr 100 files - not a
good way to run especially for frickin SQL Server.
I'm p'o'ed man.

damn

--

[Shaun Farrugia] ## [Programmer] ## [DTE Energy Operations]
[fon] 734-887-2148 [mail] farr...@dteenergy.com
o_O

[Bill Lucas]

I noticed that when we use it it always returns a failure but we noticed no
ill effects from it. After calling it and checking @@Error we observerd
that @@Error was 0 I also was in conctact with a rep from MS and they said
it may have been a documentation issue with the return code. However, the
XML Files we were using were rather small so we may not have ever reached
the same limit you are, but our clients never reported a problem with it in
the production environment.

This is the conversation I had with Mike in MS Support I posted in the .xml
newsgroup.

http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=53ce18884bdafb4&s
eekd=969340416#969340416

Here's a link to another post that preceded the one above It has code to
reproduce the issue and Mike's Reply.

http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=cb656e9f48a689dd&
seekd=970281180#970281180

Here is his workaround

http://groups.google.com/groups?q=sp_xml_removedocument&hl=en&lr=&safe=off&r
num=1&seld=969340416&ic=1

"Shaun" <sh...@bugtank.com> wrote in message
news:#9EZA5DyAHA.2252@tkmsftngp02...

[Bill Lucas]

OOPS Sorry I hit ctrl+Enter by mistake

Here is one last link that has a lot to do with it. I think this might
answer your questions with the exception of how soon is it going to be
fixed...

http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=bd501f91c582b9ea&
seekd=900065889#900065889

Hope this info helps. Posting in .xml has proven to be more useful for
these types of questions in the past.

Regards, Bill