Original author: SQL Server FineBuild1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005.23 July 2015: now over 34,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Original author: SQL Server FineBuild1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005.23 July 2015: now over 34,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

The routine sets Page Verify to CHECKSUM for SQL Server 2005. This is a more thorough method of detecting possible corruption than the Torn Page detection.

The options for Torn Page and Checksum are mutualy exclusive, so the routine explicitly turns off the old method and turns on the new and better method of checking for corruption.

Original author: SQL Server FineBuild1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005.23 July 2015: now over 34,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.