Posted by kwdavids on 10/01/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).

• Next in forum: Database instance
• Prev in forum: Re: Views vs Stored Procedures, whats the difference?
• Thread view: Re: SQL Server does not exist or access denied

[Reply to this message]