Posted by paulmac106 on 09/26/05 16:15

Hi,

Periodically I run some very complex queries or stored procedures that
"hang", and the bigger problem is that it locks up all of the database
clients ie 50 users connecting to the db via a windows application.

I never know when this is going to happen, but when it does it leaves
all the users completely hung up.

1. Can I avoid this?
2. Is there a way to "clear" what I was doing so that I don't have to
restart the SQL Server serive?

thanks,

[Back to original message]