The lock scheme configuration parameter sets the locking scheme to be used for any new table, if the create table command does not specify the lock scheme.
To see the current locking scheme, use:
sp_configure "lock scheme"
Parameter Name Default Memory Used Config Value Run Value ---------------- ----------- ----------- ------------ ----------- lock scheme allpages 0 datarows datarows
The syntax for changing the locking scheme is:
sp_configure "lock scheme", 0,
{allpages | datapages | datarows}
This command sets the default lock scheme for the server to datapages:
sp_configure "lock scheme", 0, datapages
When you first install Adaptive Server, lock scheme is set to allpages.
