ALLOW_ROW_LOCKS = { ON | OFF }
Applies to: SQL Server 2008 through SQL Server 2017.

Specifies whether row locks are allowed. The default is ON.

ON
Row locks are allowed when accessing the index. The Database Engine determines when row locks are used.

OFF
Row locks are not used.

Last modified: April 12, 2019

Author

Comments

Write a Reply or Comment