Error 1222 : Lock request time out period exceeded in Enterprise Manager 
Author Message
 Error 1222 : Lock request time out period exceeded in Enterprise Manager
When I try to open Current Activiy in the Enterprise Manager, a message box
appears :
Error 1222 : Lock request time out period exceeded
The server is running  Windows 2000 (SP1) and SQL-Server 2000 with no sp.
Any ideas?

Thanks in Advance,



Wed, 18 Feb 2004 01:01:52 GMT
 Error 1222 : Lock request time out period exceeded in Enterprise Manager

Enterprise manager is trying to run a query to fetch information to populate the screen.  The query timed out which caused the error message.

You can use SP_WHO or SP_WHO2 to get much of the same information and perhaps identify a process that is in the way of enterprise manager.

Quote:

> When I try to open Current Activiy in the Enterprise Manager, a message box
> appears :
> Error 1222 : Lock request time out period exceeded
> The server is running  Windows 2000 (SP1) and SQL-Server 2000 with no sp.
> Any ideas?

> Thanks in Advance,



Sun, 22 Feb 2004 03:02:55 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 1222 = Lock request time out period exceeded

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. Lock timeout error 1222

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

9. trapping error 1222 (lock timeout)

10. Lock timeout error 1222

11. Enterprise Manager Lock Request Timeout

12. Lock 1222 with no blocks


 
Powered by phpBB® Forum Software