For extended property update query "Lock request time out period exceeded" Error comes.
It is not solved even after 30 minutes , but solved after exe is closed.
We are not using begin/commit transactions in our code but connection is global.
Why lock on one particular table is not released(in our case extended property update query)?
Error :
Lock request time out period exceeded. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000&EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476
------------------------------
Server Name: PC\SQLEXPRESS,25111
Error Number: 1222
Severity: 16
State: 56
Procedure: sp_updateextendedproperty
Line Number: 36
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)?