Transact-SQL 2008 allows code to specify the number of milliseconds that a statement waits for a lock to be released. If the timeout is exceeded while a statement waits, the error message 1222 is raised. The default lock_timeout value is -1, which is equivalent to infinity in this context. The statement below sets that timeout […]