Pages

Saturday, September 21, 2013

SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded | Journey to SQL Authority with Pinal Dave

ERROR 1222 : Lock request time out period exceeded. MSDN Suggests solution here. It says find offending transaction and terminate it and run the query again. Though sometime there is requirement that we can not terminate anything. If we know which transaction is locking up resources and database, we need to still run the same… Continue Reading...

Source: SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded | Journey to SQL Authority with Pinal Dave