Kbase P125758: How to disable page lock in SQL server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/09/2007 |
|
Status: Unverified
GOAL:
How to disable page lock in SQL server?
GOAL:
How to change locking strategy in SQL server?
FACT(s) (Environment):
MS SQL 2000
MS SQL 2005
FIX:
To control SQL Server 2000 Lock Escalation Options,
EXEC sp_indexoption table-name, N'disallowpagelocks', TRUE;
Eg. EXEC sp_indexoption customer, N'disallowpagelocks', TRUE;