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