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:
exec
sp_indexoption
'DBName.Schema.Table', 'DisAllowPageLocks', 'TRUE'
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)