Summary information |
|
|---|---|
Default value |
allpages |
Range of values |
allpages, datapages, datarows |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Lock Manager |
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
