2 Replies Latest reply on May 10, 2018 9:43 AM by pauljordan

    Use page locks when accessing the Index




      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