Home Forums SQL Server 2005 Administering "..table "ItemNum" cannot be reorganized because page level locking is disabled" RE: "..table "ItemNum" cannot be reorganized because page level locking is disabled"

  • Thanks Patrick Schneider

    Nice solution for this problem and your Provide solution

    ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)

    is working fine in my case.

    Thanks & Regards

    Shashi Kant chauhan