Thursday, April 30, 2009

How to Disable Page Locks

You can use the following command to disable page locks on a particular table or index. Note that I wouldn't recommend doing this unless you had a very specific reason:

exec sp_indexoption 'DBName.Schema.Table', 'DisAllowPageLocks', 'TRUE'

No comments: