Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

@@LOCK_TIMEOUT (Transact-SQL)

Returns the current lock time-out setting in milliseconds for the current session.

Topic link icon Transact-SQL Syntax Conventions


@@LOCK_TIMEOUT

SET LOCK_TIMEOUT allows an application to set the maximum time that a statement waits on a blocked resource. When a statement has waited longer than the LOCK_TIMEOUT setting, the blocked statement is automatically canceled, and an error message is returned to the application.

@@LOCK_TIMEOUT returns a value of -1 if SET LOCK_TIMEOUT has not yet been run in the current session.

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 1800 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        
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.