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