• Why do you set TORN_PAGE_DETECTION OFF for SQL 2005 servers?

    Is this intentional?

    SET @sqlstring = @sqlstring + ', TORN_PAGE_DETECTION OFF, PAGE_VERIFY CHECKSUM'

    Related URL to the quesiton:

    http://www.themssforum.com/SQLServer/Torn-Page-358147/

    Scott


    Kindest Regards,

    scoinva