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


Range of values

allpages, datapages, datarows



Display level


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