lock scheme

Summary information

Default value

allpages

Range of values

allpages, datapages, datarows

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

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.

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