Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
The @@LOCK_TIMEOUT function returns the current lock timeout setting in milliseconds for the current session.
Transact-SQL syntax conventions
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 waits longer than the LOCK_TIMEOUT setting, the blocked statement is automatically canceled, and an error message is returned to the application.
If SET LOCK_TIMEOUT hasn't been run in the current session, @@LOCK_TIMEOUT returns a value of -1.
Examples
This example shows the result set when a LOCK_TIMEOUT value is not set.
SELECT @@LOCK_TIMEOUT AS [Lock Timeout];
GO
Here is the result set:
Lock Timeout
------------
-1
This example sets LOCK_TIMEOUT to 1,800 milliseconds and then calls @@LOCK_TIMEOUT.
SET LOCK_TIMEOUT 1800;
SELECT @@LOCK_TIMEOUT AS [Lock Timeout];
GO
Here is the result set:
Lock Timeout
------------
1800