Hi,

I have a SQL Server 2000 and an ASP that execute a stored procedure. It
works fine for a moment, then it suddenly stop working.
The ASP reports "Timeout Expired", but from another application developed in
delphi and from the sql query analyzer I can execute the SP.

I have to restart the server in order to the ASP works again, but it is not
true all the times.

What can I do.

Please your help

Thanks in advance.

Eduardo (from Ecuador)

[quoted text, click to view]

Sounds like you have transactions & locks interfering with each other. My
guess is that the Delphi app has used BeginTrans on a connection object.

Query analizer shows locks I think, if not you could try this tool submitted
to my forum :
http://81.130.213.94/myforum/forum_posts.asp?TID=78&PN=1

You could also try increasing some timeout values if you get desperate.
http://81.130.213.94/myforum/forum_posts.asp?TID=69&PN=1

--
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
www.adoanywhere.com
http://www.adoanywhere.com/forum

Hello Eduardo,

This seems like a typical locking/blocking issue. In addition to
Mike's info, I would like to recommend following KB articles which
would help
resolved your issue,

INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking
Problems
http://support.microsoft.com/?id=224453

HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/?id=298475


Thanks for using MSDN Managed Newsgroup.

Vikrant Dalwale

Microsoft SQL Server Support Professional


Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer’s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.



--------------------
[quoted text, click to view]
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT
NGP10.phx.gbl
[quoted text, click to view]