It's possible that there is a networking issue somewhere, but I don't think that is likely.

Reading through other threads of people with similar problems I think it might be a space allocation issue. Someone else was having a similar problem, but if they ran the stored proc in the query analyzer using the credentials of the web application user everything would start working again. I tried this and while it didn't start working immediately...

Hi all,

I have a web application which (until a few weeks ago) was running fine.

Now, periodically, a stored procedure will stop responding and timeout when called via the web application. The stored procedure varies (eg. so far this problem has happened twice and it has been a different stored proc each time) and if the stored procedure is executed in the query analyzer it executes without a problem and within a second....