DataDev: Ben Thurecht on SQL Server, C# and other bits
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:
'DBName.Schema.Table', 'DisAllowPageLocks', 'TRUE'
Share to Twitter
Share to Facebook
Share to Pinterest