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

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

ON
Page locks are allowed when accessing the index. The Database Engine determines when page locks are used.

OFF
Page locks are not used.

Last modified: April 12, 2019

Author

Comments

Write a Reply or Comment