Mega Code Archive
Viewing and Setting Current Connection Lock Timeout Settings
<![CDATA[
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>
]]>