With the SET LOCK_TIMEOUT option, it is possible to set the maximum amount of time that SQL Server allows a transaction to wait for the release of a blocked resource:
Syntax SET LOCK_TIMEOUT timeout_period
‘timeout_period’ indicates the number of milliseconds, while a value of -1 (the default) indicates no timeout period.