Cannot use the PAGE granularity hint on the table because locking at the specified granularity is inhibited.

Error:

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.

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

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

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