@@LOCK_TIMEOUT TSQL Tutorial

@@LOCK_TIMEOUT function get the current lock time-out setting in milliseconds for the current session.

@@LOCK_TIMEOUT Syntax

@@LOCK_TIMEOUT;

@@LOCK_TIMEOUT Example

SELECT @@LOCK_TIMEOUT AS Lock_Timeout;

Lock_Timeout
-1

SET LOCK_TIMEOUT 3600;
SELECT @@LOCK_TIMEOUT AS Set_Lock_Timeout;

Set_Lock_Timeout
3600

See also:
T-SQL Functions -> @@SPID