Post reply

Error: 9001 During xml operations in stored proc

  • August 10, 2004 at 1:09 pm

    #360669

    Does anyone have any experience with the transaction log becoming unavailable during xml processing?   We seem to be bumping into this situation when multiple users are testing at the same time.

    Thanks,

    Jeff


    "Keep Your Stick On the Ice" ..Red Green

  • August 13, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • August 17, 2004 at 4:30 am

    #519289

    Hi Jeff,

    What is the error the you are getting? I have never encountered such a scenario. Ofcourse using xml will reduce the performance when the hit rate is very high.

    Nivedita Sundar.N

  • August 17, 2004 at 8:27 am

    #519353

    The error was somewhat misleading...better put, it was a chain of errors all masking each other.  There are some issues with SQL Server's transaction log rolling back text and ntext transactions.  According to Microsoft this was fixed in SP 3 and above.   

    This was only a symptom of the problem we encountered.  We experienced a deadlock that triggered the whole situation.   Which reminds me..think we found a bug with the query optimizer.  Sounds like a new post??

     


    "Keep Your Stick On the Ice" ..Red Green

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply