I have a few asp.net applications that uses SQL Server 2000 as the database engine. The applications with a lot of traffic causes sleeping processes all over the place.

It sometimes causes the application to stop responding. I had a look at my recordset locks and they are all read-only.

is there a way to time-out these sleeping processes. At the moment I just go through and KILL them(a real pain)