Post reply

Reorganixing indexes

  • November 19, 2012 at 1:07 pm

    #265012

    Hi -

    While I tried to reorganize indexes, I got below error message:

    Msg 2552, Level 16, State 1, Line 1

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

    My understanding is that you can solve the issue by enabling the page level locking, but I did not know if there is an issue for doing so. I appreciate if someone tells me more about page locking and if it is ok to enable it.

    thanks,

    Lava

  • November 19, 2012 at 2:03 pm

    #1560516

    I found this very helpful link so that answered my question,

    http://connectsql.blogspot.com/2012/06/sql-server-script-to-fix-allowpagelocks.html

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

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