Does anyone know how to detect the CHECKSUM setting of the PAGE_VERIFY database option?
BOL (ALTER DATABASE) includes the following statement:
- PAGE_VERIFY { CHECKSUM | TORN_PAGE_DETECTION | NONE }
-
The current setting of this option can be determined by examining the page_verify_option column in the sys.databases catalog view or the IsTornPageDetectionEnabled property of the DATABASEPROPERTYEX function.
However, there is no column named page_verify_option in the view sys.databases, and DATABASEPROPERTYEX('IsTornPageDetectionEnabled') does not discriminate between the settings CHECKSUM and NONE (it returns 0 for both)!