New answers and comments are not allowed. It works fine with empty tables or tables with hundreds of records. Are there parameters to specify the lock timeout What could be locking it The table has about 10k records.

I got also in MsSQL Server Management Studio the message that the datas where locked. General Discussions This is a migrated thread and some comments may be shown as answers. This message implies that whatever transaction is running is not able to take lock on resource to perform the activity.Today is Monday( Issue started on friday) ,so are you still getting this issue What version or SQL Server we are talking about.Can you click on new query and query DMV sys.dmtranlocks filter your table name use below link. I'm trying to encrypt a column and am getting the following error: Set-SqlColumnEncryption : Lock request time out period exceeded. I ran the trace and found that it failed due to 'lock escalation' event. Msg 1222, Level 16, State 55, Server XXXXXX, Procedure MyStoredPROC, Line 165 Lock request time out period exceeded. at .() at .rsNext() at .hasNext() at .ThrowException(Exception e) at .ExceptionWrapper.Throw() at .fetchNextQueryResult(ApplicationContext context, RunningQuery runningQuery, Int32 skipAmount) at (QueryResultWrapper aQrs, Int32 skipAmount) at _Item(Int32 indexParam) at .tCurrent(Int32 _pos) at .ListEnumerator.Move(Int32 relative) at .ListEnumerator.MoveNext() at `1.() at `1.ctor(IEnumerable`1 collection) at . Case 1: People want to edit datas but a whole range (in the analyced case 44 records) are locked although the records where created 3 weeks before and no one is working on them. Warning: Null value is eliminated by an aggregate or other SET operation. Search: Jenkins Timeout Has Been Exceeded. : .sql.SQLException: Lock request time out period exceeded.

Following along with a tutorial, I'm trying to create a table, first via the SSMS interface. We get very weird error - 'Lock request time out period exceeded' SQL Server query analyser does not repond at all. Used to be a SQL programmer years ago and now just decided to revisit SQL via SSMS. I would speak to your DBA about this to establish what other work is happening on the database at the same time that could be. By default it uses repeatable.read, but you can change this in the config. We are using Telerik Open Access version = v7 in our ASP.NET (3.5) application. To do this it takes a lock on the database, and it looks like this is failing: SQLServerException: Lock request time out period exceeded.