Posted by kwdavids on 09/26/06 11:38

Thanks Hugo,

Yes the "fix" does result in intermittent long waits.

While the application was "waiting" I ran sp_lock and sp_who2 and I
didn't see that anything was waiting for a lock. I also tried to
connect to the database from Enterprise Manager and got the Error
message (it times out pretty quick).

[Back to original message]