System Settings MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Settings
  4. Viewing and Setting Current Connection Lock Timeout Settings
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>