>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
>

>
Hi Fabio,

How does it affect a SP execution and is there a way to increase time for SP?

Thanks in advance.