Tag Archives: Line 1

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