Stored procedure must be re-created

  • Thread starter Thread starter Ilia
  • Start date Start date
I

Ilia

Hello,

we have a strange problem with a stored procedure on MS SQL Server 2000 SP3.
The procedure is pretty complex and use temporary tables to create XML with
FOR XML EXPLICIT. We read the XML data with ExecuteXmlReader in our ASP.NET
application (.NET Framework 1.1).

Most of time everything works well, but sometimes we get errors as no data
are read. We have to re-create the procedure on the SQL Server (ALTER
PROCEDURE with the original code) to make our program run again. It could be
enough sometimes to run the procedure in Query Analyzer.

Have somebody any idea, what we have to check or change?

Thanks
Ilia
 
Hi llia,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you sometimes get an error and no data
was returned when using ExecuteXmlReader build an XmlReader object. If
there is any misunderstanding, please feel free to let me know.

Based on my experience, this problem is quite complex. As it occurs
occasionally, we have to do some step for troubleshooting:

1. When the error occurs, is there any error message shown? If yes, what's
the error message.
2. If you run the sotred procedure in Query Analyzer, could it be
reproduced?
3. Under what circumstances will the error occur?

Could you paste the stored procedure here? It will help us to deliver our
assistance more quickly. Thank you for your cooperation.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top