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 […]
Tag: Level 16
Error Msg 1807, Level 16, State 3, Line 1 Resolution The resolution of this error in Sql server is quick and easy to fix:- Error Message:- Msg 1807, Level 16, State 3, Line 1 Could not obtain exclusive lock on database ‘model’. Retry the operation later. Msg 1802, Level 16, State 4, Line 1 CREATE […]