Tag Archives: Page verify option

T-SQL script to list Page Verify Option of all user Databases in sql server 2008/2005

— Script to list All user databases and their page verify option set. SELECT  name AS [Database] , CASE WHEN page_verify_option = 0 THEN ‘NONE’ WHEN page_verify_option = 1 THEN ‘TORN_PAGE_DETECTION’ WHEN page_verify_option = 2 THEN ‘CHECKSUM’ END AS [Page Verify] … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , , , , | Leave a comment