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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error in Table

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_period

A value of -1 (default) indicates no time-out period (that is, wait forever).
Go to Top of Page
   

- Advertisement -