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


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

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: