Specifying a server-wide locking scheme

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.