Hi
This might be of some use, see BOL for more detailed info
@@LOCK_TIMEOUT
Returns the current lock time-out setting, in milliseconds, for the current session.
Syntax
@@LOCK_TIMEOUT
Return Types
integer
Remarks
SET LOCK_TIMEOUT allows an application to set the maximum time that a statement waits on a blocked resource. When a statement has waited longer than the LOCK_TIMEOUT setting, the blocked statement is automatically canceled, and an error message is returned to the application.
At the beginning of a connection, @@LOCK_TIMEOUT returns a value of -1.