SQL Server Error 1222 lock request time out period exceeded
SQL Server Error 1222 lock request time out period exceeded
Lock request time out period exceeded using SSMS in SQL Server
The error message:
lock request time out period exceeded. (microsoft sql server, error: 1222)
SQL Server Error 1222 lock request time out period exceeded is related to the time out of query due to locking of resources in SQL server.
Lock request time out period exceeded. (.Net SqlClient Data Provider) using SQL Server Management Studio.
Why and How to fix:
The error message “Lock request timeout period exceeded Error 1222” indicates that a transaction is holding a lock on the target resource for a longer period than the query could wait for.… Read the rest