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.

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