p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   error 1222: lock request time out exceeded (http://p2p.wrox.com/showthread.php?t=20373)

jpenn October 25th, 2004 03:12 PM

error 1222: lock request time out exceeded
 
I am using sql server 2000. I get this message when i try to access current ativity in enterprise manager:
error 1222: lock request time out exceeded
I ran the sp_lock in sql query analyzer but i do not know what the information i recieve means. I need to stop whatever is blocking me from seeing the current activity.

happygv October 25th, 2004 10:05 PM

Check this link - INF: Refresh of Current Activity in SEM May Cause "Error 1222: Lock Request time out period exceeded" Error Message

As it reads on that page... A second refresh usually results in success. However, if the locks are held for an extended period the error message may occur again. If you execute the sp_lock stored procedure, you can evaluate which process is holding locks on Object IDs 1, 2 and 3 of the dbid 2 (tempdb).

Also check out this Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection


All times are GMT -4. The time now is 06:33 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.