Error 1222 = Lock request time out period exceeded 
Author Message
 Error 1222 = Lock request time out period exceeded
Using SQL Server 2000, when in SQL Server Enterprise
Manager.  I have a Error 1222 = Lock request time out
period exceeded.

Is there a fix available to resolve this problem.



Fri, 03 Jun 2005 10:04:00 GMT
 Error 1222 = Lock request time out period exceeded

Without more background information it's hard to say what's going on in this
case.

The LOCK_TIMEOUT setting (see also books online) determines how long to wait
on a lock before aborting the transaction. In your case some transaction

see if it is set to a reasonable value; try using SET LOCK_TIMEOUT to modify
the setting.

HTH,
fl.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


Quote:
> Using SQL Server 2000, when in SQL Server Enterprise
> Manager.  I have a Error 1222 = Lock request time out
> period exceeded.

> Is there a fix available to resolve this problem.



Sat, 04 Jun 2005 03:43:14 GMT
 Error 1222 = Lock request time out period exceeded
Are you able to repro this issue consistently?  If so, can you please advise
what you were doing when this was occurring?  Which service pack of SQL
Server 2000 are you running on?

Thanks Corinna & Florian

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Quote:
> Using SQL Server 2000, when in SQL Server Enterprise
> Manager.  I have a Error 1222 = Lock request time out
> period exceeded.

> Is there a fix available to resolve this problem.



Fri, 03 Jun 2005 19:17:04 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Error 1222 : Lock request time out period exceeded in Enterprise Manager

2. SQL Server 7: Error Msg - Error: 1222, Severity: 16, State: 50 Lock Request Timeout period exceeded

3. Error 1222: lock request timeout period exceeded

4. Lock request time period exceeded error

5. 1222 (lock time out) is untrappable

6. Lock Request Time out Period ..

7. Unstable sql server - locking/blocking/1222 errors help pls

8. trapping error 1222 (lock timeout)

9. Lock timeout error 1222

10. Lock timeout error 1222

11. Lock 1222 with no blocks

12. Error 1222


 
Powered by phpBB® Forum Software