How to Remove all the Xml Documents from the Cache Memory?

• AMI.HANEES

  Old Hand

  Points: 355

  More actions

  November 29, 2005 at 3:07 am

  #92263

  Hai friends,

   

  I am using sp_xml_preparedocument stored procedure to prepare the xmldocument.  but unfortunately i forget to remove the documents.

  I keep on creating the documents. At one stage, the following error will came

  Server: Msg 6624, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1

  XML document could not be created because server memory is low. Use sp_xml_removedocument to release XML documents.

   

  So, Now i want to remove all the xml document from cache memory immediately.

  If u have a solution, pls post it.

   

• bledu

  SSChampion

  Points: 12335

  More actions

  November 30, 2005 at 6:38 am

  #606697

  i think restarting the sql server will solve the problem. i can't think of any other way.

  ---

  Everything you can imagine is real.
  

• peterhe

  SSChampion

  Points: 11469

  More actions

  November 30, 2005 at 7:28 am

  #606725

  You can try the following trick:

  DECLARE @N int

  SET @N=1

  -- Instead of 1000, assign a reasonal value to compare.

  WHILE @N<1000

  BEGIN

  exec sp_xml_removedocument  @N

  SET @N=@N+1

  END