lock scheme

lock scheme sets the default locking scheme to be used by create table and select into commands when a lock scheme is not specified in the command.

Summary Information

Default value

allpages

Range of values

allpages, datapages, datarows

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Lock Manager

The values for lock scheme are character data, so you must use 0 as a placeholder for the second parameter, which must be numeric, and specify allpages, datapages, or datarows as the third parameter:
sp_configure "lock scheme", 0, datapages