Tag Archives: Msg 2552

Index cannot be reorganized because page level locking is disabled

Index cannot be reorganized because page level locking is disabled Hi Friends, recently my Index reorganize job is failed. When I checked about error: “The index “cndx_PrimaryKey_AsyncOperation” (partition 1) on table “AsyncOperationBase” cannot be reorganized because page level locking is disabled.”.  Solution: A DBA can resolve the above error message by enabling Page Level Locking on the index