• OLDCHAPPY (6/11/2013)


    thanks. unfortunately its SAP so i can't change anything. it would be super cool if MS would make a more intelligent reindex/reorg task that could skip indexes with allow page locks.

    In my experience, allow_row_locks = 0 or allow_page_locks = 0 are usually set that way by accident. In at least one version of SSMS, it seemed to get set that way by accident a lot.

    You might try asking the vendor about that to see if it OK to make the change. There is probably at least a small chance that they won't give you the usual BS that you get from vendors when you point out an error. 🙂