Code Analysis

DEP016

Page last updated 05 February 2021

TORN_PAGE_DETECTION option is deprecated

The TORN_PAGE_DETECTION option only checks the first 2 bytes in every 512-byte sector. Corruption could exist between the Torn page detection bits.

Use the CHECKSUM option instead of TORN_PAGE_DETECTION.

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard


Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal