Page Comparison

SELECT 'ateralter table [' + schema_name(t.schema_id) + '].[' + t.NAME + 
	'] set (LOCK_ESCALATION=DISABLE);' AS stmt
FROM sys.tables t
WHERE lock_escalation <> 0
UNION ALL
SELECT 'ALTER INDEX [' + i.NAME + '] on [' + schema_name(t.schema_id) + '].[' + t.NAME + 
	'] set (ALLOW_PAGE_LOCKS=OFF);' AS stmt
FROM sys.tables t
INNER JOIN sys.indexes i ON (i.object_id = t.object_id)
WHERE i.NAME IS NOT NULL
	AND allow_page_locks <> 0