Browse by Tags

All Tags » sql server » indexes » service pack » allow_page_lock (RSS)
Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled.
Published 7 August 7 8:43 AM | SSQA.net
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 "<name>"...
Filed under: , , , , ,