Saturday, February 25, 2012

PAGE_VERIFY setting CHECKSUM - how to detect?

Does anyone know how to detect the CHECKSUM setting of the PAGE_VERIFY database option (2005 only)?

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)!

Actually, I was looking in sys.sysdatabases! sys.databases is just fine....

No comments:

Post a Comment