Post reply

PAGE_VERIFY setting CHECKSUM - how to detect?

  • August 30, 2006 at 5:23 am

    #172333

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

  • August 30, 2006 at 7:00 am

    #657486

    There is a column name page_verify_option in this view anyway try the following query

     

    select

    name, page_verify_option, page_verify_option_desc from sys.databases

     

    hth

     

    David

  • August 30, 2006 at 7:06 am

    #657492

    Thanks!

    I was looking in sys.sysdatabases!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply