Lock request time out period exceeded
-
When I tried to access to all the objects of a database from SQL Query Analyzer, I got this error "Lock request time out period exceeded" and am refused to access. Why? How to solve this problem?
-
Have you set a specific lock time out value for QA? Check under Tools|Options.
Andy
-
Also is not, is this the only app having troubles?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
Refreshing the current activity in turn calls the sp_MSset_current_activity
Lock request time out period exceeded.
Server: Msg 1222, Level 16, State 1, Line 1
Lock request time out period exceeded.
The statement has been terminated.
The statement has been terminated.
I chceked on sp_lock, DBCC Opentran found no block. Only thing some db jobs were running for long time. I try to stop them could not, hence stopped the SQL Agent. Still got the same error message.
Then stopped and started the sql server services..
I appreciate and thank ,If anyone could advise what cause these problem.
- S Sivaprasad
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply