Maintenance job Index error

• tt-615680

  SSCertifiable

  Points: 7835

  More actions

  June 13, 2014 at 2:22 am

  #287446

  Dear All,

  I have a database maintenance job which does a Reorganize Index but I keep getting the following error:

  " failed with the following error: "The index "" (partition 1) on table "

  " 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.

  Is there anything I would be able to do to resolve the issue please?

  Thank you in advance!

• r.dragoi-1095738

  SSCrazy

  Points: 2022

  More actions

  June 13, 2014 at 5:03 am

  #1721407

  Try to enable the page lock for the index :

  ALTER INDEX < Index name > ON < Table Name >

  SET (

  ALLOW_PAGE_LOCKS = ON

  )