Using the @@LOCKTIMEOUT Function - @@LOCKTIMEOUT Example
Microsoft SQL Sample Code
The builtin @@LOCKTIMEOUT function allows an application to set the maximum time that a statement waits on a blocked resource. When a statement has waited longer than the LOCK_TIMEOUT setting, the blocked statement is automatically canceled, and an error message is returned to the application. The code script below will show you how to use the @@LOCKTIMEOUT function. For more details on the @@LOCKTIMEOUT function
@@LOCKTIMEOUT Example
If you need any help implementing these
functions or modifications made for your needs, please
Contact Us to get a free
quote for your Microsoft
SQL Server Development needs.
Learn more about the
quoting process we use at WSI.