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?
Did you ever get this sorted?