advlgx
asked on
Page Level Locking on Index. What is it?
When I try to reorg a table that has an index on it, I get this error:
The index "IX_ClientName" (partition 1) on table "Client" cannot be reorganized because page level locking is disabled.
Should I enable this in the index options? What are the ramifications? What does this mean?
It is a non-unique, non-clustered index.
The index "IX_ClientName" (partition 1) on table "Client" cannot be reorganized because page level locking is disabled.
Should I enable this in the index options? What are the ramifications? What does this mean?
It is a non-unique, non-clustered index.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.