Hi.
I'm developing an application using Azure SQL Database for an external database.
According to the official reference, the isolation level of SQL Server is "Read Uncommitted".
Is Azure SQL Database "Read Uncommitted" as well?
If you know about this, please let me know.
Hi Yori,
default isolation level for Azure SQL Database is RCSI – Read Committed Snapshot Isolation level. What if you decide to not use this and you want to turn it off and go back to read committed
ALTER DATABASE CRMDB SET READ_COMMITTED_SNAPSHOT OFF
ALTER
DATABASE
CRMDB
SET
READ_COMMITTED_SNAPSHOT
OFF
ALTER DATABASE CRMDB SET ALLOW_SNAPSHOT_ISOLATION OFF
ALLOW_SNAPSHOT_ISOLATION
SELECT name, snapshot_isolation_state,snapshot_isolation_state_desc, is_read_committed_snapshot_on
SELECT
name
, snapshot_isolation_state,snapshot_isolation_state_desc, is_read_committed_snapshot_on
FROM sys.databases
FROM
sys.databases
WHERE name = 'CRMDB'
WHERE
=
'CRMDB'
Hi CV.
thanks for your reply.
I was worried about dirty reads, but I understand that can use read committed.
thanks :)
Yori.