TornPageDetection Property
The TornPageDetection property enables Microsoft® SQL Server™ 2000 logic-enhancing data security in the event of certain types of system failure.
Applies To
| DBOption Object |
Syntax
object.TornPageDetection [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetTornPageDetection(LPBOOL pRetVal);
HRESULT SetTornPageDetection(BOOL NewValue);
Remarks
If TRUE, SQL Server marks units of a database page prior to attempting a write and checks page marking on every read.
If FALSE, database pages are not marked or evaluated.
For more information, see Setting Database Options.