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.