enumerate prepared xml documents

Is it possible to obtain list of handles returned by
sp_xml_preparedocument?
What I want is to manually release all xml documents allocated by
sp_xml_preparedocument without server restart.
At some point server runs out of memory. We might have bugs in our code(not
calling sp_xml_removedocument) so I want to check if it is actually an issue
of not calling sp_xml_removedocument or may be something else.
Thanks,
Shurik.Hi
Once you should have finished with the document you should call
sp_xml_removedocument to release it. If you don't I do not think there is a
way of doing this without knowing the handle.
John
"Oleksandr Brovko" wrote:

> Is it possible to obtain list of handles returned by
> sp_xml_preparedocument?
> What I want is to manually release all xml documents allocated by
> sp_xml_preparedocument without server restart.
> At some point server runs out of memory. We might have bugs in our code(no
t
> calling sp_xml_removedocument) so I want to check if it is actually an iss
ue
> of not calling sp_xml_removedocument or may be something else.
> Thanks,
> Shurik.
>
>sql

Entering null into blank fields in the database

How can I enter NULL manually in one of the rows in Sql Server database. Those rows does not contain any data.
you can use DbNull.Value. If its a datetime datatype you need to use SqlDateTime.Null and import Sqltypes namespace.
|||well the problem is bit different. I have 4 rows with 4 fields each. Like Name, Age, Address, Phone number.
Now Name, Age , Address is filled with some data. But I forgot to adddata for the phone and now its just blank. How can I make this nullinstead of blank.

|||UPDATE
<table>
SET
[phone]= NULL
WHERe
[phone] = ' '