Viewing and Setting Current Connection Lock Timeout Settings : LOCK_TIMEOUT « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. LOCK_TIMEOUT
5> -- 1000 milliseconds, 1 second
6> SET LOCK_TIMEOUT 1000
7> SELECT @@LOCK_TIMEOUT
8>
9> -- Unlimited
10> SET LOCK_TIMEOUT -1
11> GO

-----------
       1000

(1 rows affected)
1>








26.17.LOCK_TIMEOUT
26.17.1.Using SET LOCK TIMEOUT
26.17.2.Viewing and Setting Current Connection Lock Timeout Settings