Msg 651, Level 16, State 1, Line 1
Cannot use the PAGE granularity hint on the table [table name] because locking at the specified granularity is inhibited.

This error could occur due to creation of indexes on the table with ALLOW_PAGE_LOCKS = OFF

Check the indexes on the table to see if there is any index with ALLOW_PAGE_LOCKS off.

SELECT * FROM sys.indexes
WHERE ALLOW_PAGE_LOCKS = 0 and object_name(object_id) = [table name]

Replace the [table name] with the table name in the error and check if there are any indexes with ALLOW_PAGE_LOCKS disabled.

1. Disable the index or change the index to enable page locks.
2. Use row locks or table locks instead.

Leave a Reply

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