Hi Neil,

Thank you for your reply. I'm using SQL Server 2000 Enterprise Edition.


>Is it the MSDE Version or the Full Version of MSSQL?
>
>>Hi All,
>>
>>My SQL Server database always suffering a process that block by other process.
>>I can check it using SP_WHO and SP_WHO2 stored procedure.
>>There are so many process ID that is idle by still block some other process that is some other process cannot execute successfully.
>>The application was developed using JAVA but I don't know JAVA. My rule in the database is a DBA.
>>I'm a new DBA since I'm a developers from my previous job but I don't know JAVA since I'm only using microsoft products.
>>
>>My question is, Is there a way to automatically kill the idle process that block other process.
>>As of now I have manually kill the process using the KILL command to allow other process to execute.
>>What I have done is to check the available process in the DB Server and determine which process causes the lock and kill it manually.
>>Our application always suffering a deadlock because of idle process that block other process.
>>We are on the process of investigating it. This is my big puzzle that needs to resolve.
>>I have already check my SQL Server and OS configuration and there is no problem on my configuration.
>>
>>Anybody can help me to resolve my problem.
>>
>>
>>Thanks,
>>
>>
>>Rene