0 Replies Latest reply on Nov 24, 2017 7:50 AM by nipper42

    Daily Maintenance failing on the re-orginization step


      Hi We are getting the following error message when re are trying to reorganize the index as part of our Daily Maintenance Plan 'Executing the query "ALTER INDEX [CI_HostName] ON [dbo].[OrionServers] ..." failed with the following error: "The index "CI_HostName" (partition 1) on table "OrionServers" cannot be reorganized because page level locking is disabled.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.' I have checked the index in question and the 'Use page locks when accessing the index' is disabled.  My question is can this be enabled or is there a reason for this being disabled?


      Please advise


      Regards Daniel