Exception_acces_violation

[soulspysti]

Hi,

I'm calling a COM DLL from SQL Server Analyser, and in this DLL an EXCEPTION_ACCES_VIOLATION (sqldumpexceptionhandler) error popup when I call a specific SP, but many SPs has been called and execcuted when this one come. Not over, this SP call a system sp sp_xml_preparedocument.
I'm using server 2000, sqlserver 2000 sp4 and and ms xml 4 sp2.

PLEASE HELP

Soul_Spy

[iburyak]

If you use this proc you have to make sure you use
sp_xml_removedocument as well each time the first one executed and you no longer need it.
The problem with this proc that it overloads your memory after several executions and you need to reboot a server to fix this problem.