error 1222: lock request time out exceeded

jpenn · #1 (**permalink**) October 25th, 2004, 03:12 PM

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 · #2 (**permalink**) 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
File Sharing lock count exceeded	williamlove	Access	11	August 3rd, 2018 02:44 AM
sp update error 1222	Gunny	SQL Server 2000	1	August 21st, 2006 12:47 PM
Maximum Request Length exceeded?	dparsons	ASP.NET 1.0 and 1.1 Professional	0	March 23rd, 2006 12:41 AM
Outputto exceeded limit of rows	Renee Voice	Access VBA	2	February 26th, 2006 04:47 PM
Error 1222 - When accessing Client activity	ryant	SQL Server 2000	1	March 16th, 2004 08:25 AM