Post reply

Tried to reorganize index

  • November 10, 2010 at 8:02 am

    #231225

    I tried to run this statement:

    alter index [index_name] on [schema_name].[table_name] reorganize

    but got an error:

    The index "index_name" (partition 1) on table "table_name" cannot be reorganized because page level locking is disabled.

    Where can I find an information about page level locking and how to unlock it? This is a part of our nightly job and I got this message for several days in a row.

  • November 10, 2010 at 8:08 am

    #1248906

    try this

    Run ALTER INDEX command with SET (ALLOW_PAGE_LOCK = ON)

  • November 10, 2010 at 8:33 am

    #1248928

    Thanks, it works. I ran it for rebuild index.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply