MSSQL Transport Isolation levels

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?

Many thanks

Hi Rod,

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.


Thanks Kyle for the response.