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

Enterprise Mgr

I have recently installed MSDE on my computer. Now I need to get a copy of
Enterprise Mgr or equivalent. Does anyone know if I can obtain this from
somewhere without having to purchase anything from M$http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--

Enterprise Managers "current activity":How in SQL?

Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System AdministratorAlso, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator|||Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred Braun|||Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Enterprise Managers "current activity":How in SQL?

Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred BraunManfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "current
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
>> Hi All !
>> Can someone show, how to obtain that, what Enterprise manager calls
>> "current activity", in SQL? I really would like to see the same output,
>> not that, what sp_who, sp_lock etc give.
>> I just have currently not the right knowledge to make all the neccessary
>> relationships from sp_who/sp_lock/sysprocesses etc
>> Any help would be great.
>> Thanks so far and
>> best regards,
>> Manfred Braun
>>
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator