Error: Cannot use the ROW granularity hint on the table because locking at the specified granularity is inhibited
[sourcecode language=”sql”] SELECT name indexname FROM sys.indexes WHERE object_id = object_id(‘XYZTable’) AND allow_row_locks = 0 AND allow_page_locks = 0 [/sourcecode]