Re: the return value of sp_XML_removedocument

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Kass (skass_at_drew.edu)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 01:47:10 -0400

Peter,

  I should have searched the archives before posting... I found many
posts about this, including the one copied below from Dan Doris
[Microsoft] a couple of years ago. Maybe the suggestion here will
help. If I had to guess, I'd say that this bug just hasn't been
considered serious enough to "make the cut" and be addressed. If you
can't make the workaround work, let us know.

SK

[From microsoft.public.sqlserver.xml, July, 2002]
Thanks for reporting this, i'll open a bug on this as i can repro this. A
suggestion if you want to work around the problem will be check @@error and
test it to see if is non-zero as the return value when an invalid handle is
passed into sp_xml_removedocument.

peter wrote:

>I posted this in sqlserver.xml forum this morning. No response yet. Anyone here knows it? Thanks
>
>The original post:
>
>according to BOL, if sp_xml_removedocument returns 0, it's succeeded; >0 failed.
>
>But when I checked the result, it always returns 1.
>
>I tried on several sql server boxes.
>
>Server 1: SQL Server Enterprise 2000 SP3, Windows Server 2003 Standard. MSXML 8.0.6730.0
>Server 2: SQL Server Enterprise 2000 SP3, Windows Server 2000 SP4. MSXML 8.0.6730.0
>Server 3: SQL Server Enterprise 2000 SP3, Windows Advanced Server 2000 SP3. MSXML 8.0.6730.0
>
>I am digging into this becuase I some times get the following error:
>"XML document could not be created because server memory
>is low. Use sp_xml_removedocument to release XML
>documents." in my clients. The clients call several stored procedures which take xml document as parameters and use sp_XML_preparedocument,OPENXML and sp_XML_removedocument.
>
>Now I want to check the return value of the procedure sp_xml_removedocument, but each time it returns 1. Is BOL wrong?
>
>Thanks in advance
>
>
>
>

Relevant Pages

  • Re: Giving an application a window icon in a sensible way
    ... which attracts those posts you don't seem to enjoy receiving. ... insulting, instructing, or other such tone rather than being ... Saying you found a bug is ... They have emotions, ...
    (comp.lang.java.programmer)
  • Re: Newsbin Pro users?
    ... Brian Kraft wrote: ... a third party out, Brian. ... The posts came from Giganews and Easynews ... I am now able to report the upgrade is available, bug ...
    (news.software.readers)
  • Re: Processor Manufacturers
    ... Oh Puuulease stop with the free access and free speech nonsense. ... You've said yourself on this very forum that you censor posts on your ... repetitive indentical bug reports about a bug that does not exist, ... Still have your head in the sand about that defect in your code, ...
    (alt.lang.asm)
  • Re: WGA thoughts
    ... >It is amazing the number of posts you see now with wga validation issues. ... Its a bug that needs to be worked out. ... xpi codes you can read everything. ...
    (microsoft.public.windowsxp.general)
  • Re: [slrn] Cant Convert Msg
    ... This is a bug or feature of slrn pl2, ... IANA list of character sets. ... those posts. ...
    (news.software.readers)