I have a database in SQL Server 2000 that i'm converting (upgrading) to 2005.
When i make the restore from the SQL Server 2000 in the SQL Server 2005, this database is still with the option of torn_page_detection on, and the checksum option is set to false.
I'm thinking in changing the option from torn_page_detection to checksum, what do you think? I read that is more secure. Will i have any problems with my existing applications? what do you masters do in this case?