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"

  • Page level locking can be set using the CREATE INDEX or ALTER INDEX statements :

    ALTER INDEX index_name ON table_name SET (ALLOW_PAGE_LOCKS = ON)

    The allow_page_locks column of sys.indexes view may help you find indexes having page level locking disabled.

    Hope this helps.

    Patrick