T-SQL Tutorial

T-SQL SET Lock_Timeout


SET Lock_timeout - sets the number of milliseconds of statement that waits for a lock to be released.

SET Lock_timeout Syntax:

SET LOCK_TIMEOUT milliseconds_number ;

SET Lock_timeout Example:

SET LOCK_TIMEOUT 3600;
GO

Messages:
Command(s) completed successfully.