Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
nalin_769
Starting Member
16 Posts |
Posted - 2009-03-02 : 06:33:37
|
When try to open or delete following error will display "lock request timeout period exceeded" Thank You |
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-02 : 06:55:52
|
The records of a table that you want to select or delete are already loacked by another process and you would only be able to access those after the completion of that process. If you want to wait for sepcific time period set the Lock_Timeout setting before statement as below:SET LOCK_TIMEOUT timeout_periodA value of -1 (default) indicates no time-out period (that is, wait forever). |
 |
|
|
|
|