The TornPageDetection property enables Microsoft® SQL Server™ 2000 logic-enhancing data security in the event of certain types of system failure.
object.TornPageDetection [= value]
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Boolean
Read/write
HRESULT GetTornPageDetection(LPBOOL pRetVal);
HRESULT SetTornPageDetection(BOOL NewValue);
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.