• ALLOW_PAGE_LOCKS can but may not lead you to deadlocks. However if you have a very busy OLTP system, page level locks hits concurrency. But remember, if you disable this there will be more number of locks for SQl server to handle this also can lead total slowdown of system.

    ALLOW_PAGE_LOCKS will not affect rebuild (which is essentially drop and create), but you cannot reorganize the index

    http://msdn.microsoft.com/en-us/library/ms188388.aspx

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]