Categories
Sql Server

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 […]

Categories
Sql Server

Error Msg 1807, Level 16, State 3, Line 1 Resolution

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 […]