MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1645

I was under the impression that you had to first set PAGE_VERIFY option.

http://msdn.microsoft.com/en-us/library/bb402873(SQL.90).aspx

By default, all databases in SQL Server 2005 has the PAGE_VERIFY option set to CHECKSUM so this should be ok. If you have upgraded your databases from SQL Server 2000, the settings will be retained - either TORN_PAGE_DETECTION or NONE, depending on how it was configured prior to upgrade. A recommendation is to set the PAGE_VERIFY option in SQL Server 2005 to CHECKSUM. Just validate that your databases are set to CHECKSUM

select name, page_verify_option_desc
from sys.databases
order by name