1 Reply Latest reply on Feb 9, 2018 8:40 PM by rebelezna

    Use page locks when accessing the Index

    nipper42

      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