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 
                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.