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 Unit Type ---------------- ----------- ----------- ------------ ----------- -------------- ----------- lock scheme allpages 0 datarows datarows name dynamic
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 data pages:
sp_configure "lock scheme", 0, datapages
When you first install Adaptive Server, lock scheme is set to allpages.
