@@LOCKTIMEOUT Function - SQL Server

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


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.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.