devxlogo

Lock Timeout!

Lock Timeout!

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

size=3>
‘timeout_period’ indicates the number of milliseconds, while a value of -1 (the default) indicates no timeout period.

devx-admin

Share the Post: