SQL Server Performance

Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 7, 2007.

  1. Anonymous New Member

    All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "&lt;name&gt;" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled. Using ALTER INDEX REORGANIZE statement as reinstated in the BOL ... the index leaf level will be reorganized. This clause is equivalent to...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/07/msg-2522-the-index-name-partition-1-on-table-accounting-line-cannot-be-reorganized-because-page-level-locking-is-disabled.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1299" width="1" height="1">

Share This Page