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]

 Share!

 
comments powered by Disqus