Cannot use the %ls granularity hint on the table “%.*ls” because locking at the specified granularity is inhibited.

This error occurs when the lock cannot be applied on a specific table at a specified granularity.

It occurs for two granularity levels:
ROW
PAGE

For more information on ROW granularity locking error follow this link:
Cannot use the ROW granularity hint on the table because locking at the specified granularity is inhibited.

For more information on PAGE granularity locking error follow this link:
Cannot use the PAGE granularity hint on the table because locking at the specified granularity is inhibited.

Leave a Reply

Your email address will not be published. Required fields are marked *