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

Posted on : 30-04-2012 | By : Devi Prasad | In : SQL Errors

Share:

0


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.




References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: , ,