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