Maintenance plan fail after upgrade due to Page Level Locking
We have maintenance plans failing because of Page Level Locking being unticked at some indexes.
Scanner001 (Liam right?) has posted an idea: https://www-secure.symantec.com/connect/idea/page-level-locking
I am no SQL man, but is there a query to check if PLL is being set at indexes?
If it is not set (i checked, and it is indeed not on an index mentioned), can it be turned on without problems? Are there indexes that should not have this ticked?