MS SQL XML - Use sp_xml_removedocument to release XML documents

Author

Use sp_xml_removedocument to release XML documents

brendanjobs@yahoo.co.uk

2005-07-06, 9:23 am

Hi
i've been using openxmnl to isert some xml files into SQLserver
2000(SP3) database. everything was ok until yesterday i get the message

Use sp_xml_removedocumen
t to release XML documents.Use
sp_xml_removedocumen
t to release XML documents.

Does anyone know a workaround to this problem. my code uses the
u_xmlfile_preparedoc
ument & sp_xml_removedocumen
t routines.

how can you clear the memory so i can continue processing XML files. At
the moment i cant process any XML file therefore i cant use
sp_xml_removedocumen
t.
Thanks

Michael Rys [MSFT]

2005-07-13, 3:23 am

If you close and reopen the connection, you should have released the memory.
Are you sure that you have enough memory available?

Best regards
Michael

<brendanjobs@yahoo.co.uk> wrote in message
news:1120661282.977127.67150@f14g2000cwb.googlegroups.com...
> Hi
> i've been using openxmnl to isert some xml files into SQLserver
> 2000(SP3) database. everything was ok until yesterday i get the message
>
> Use sp_xml_removedocumen
t to release XML documents.Use
> sp_xml_removedocumen
t to release XML documents.
>
> Does anyone know a workaround to this problem. my code uses the
> u_xmlfile_preparedoc
ument & sp_xml_removedocumen
t routines.
>
> how can you clear the memory so i can continue processing XML files. At
> the moment i cant process any XML file therefore i cant use
> sp_xml_removedocumen
t.
> Thanks
>

Sponsored Links