I read here and here that, when connecting to a Sql Server read-only replica, the isolation level used is ALWAYS
SNAPSHOT. It says it ignores
SET TRANSACTION ISOLATION LEVEL statement and any locking hints.
Is this true?
Is it also true for Azure SQL Database replicas?
What happens if the snapshot isolation level is disabled?