>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

Set a Timeout.

You can use a Connection interface timeout ( this is a job timeout )
or a T-SQL lock timeout ( more precise )

* ODBC
sqlsetpro(m.stmt,"ConnectTimeOut",5)
* T-SQL
SET LOCK_TIMEOUT timeout_period


Fabio