Hi, the docs contain the supported isolation levels for SQL, and the default is Read Committed. My question is Read Committed Snapshot Isolation (RCSI) supported for NserviceBusTransport - On-Prem SQL Server.
I can see that Azure SQL is documented, which uses RCSI by default, but just wanted to check if SQL Server is also supported for this?
I don’t believe this is supported for on-prem SQL Server. Snapshot isolation would interfere with our readpast hint which doesn’t work if DELETE does not lock the record.