Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use.

The SET TRANSACTION ISOLATION LEVEL command in BOL (ah! see, I can use google and BOL) nothing seems to be named "chaos" and ADO.NET does have 5 modes that match up nicely to documented levels in addition to "chaos"

What or who is this Chaos level for? (And why does it have an unfriendly name?)

Refs: The ADO.NET enum

share|improve this question
Can you link to the relevant documentation that mentions a "chaos" isolation level? It might just be a scary name for READ UNCOMMITTED. –  Nick Chammas Nov 28 '11 at 18:44
Added a ref to the enum –  MatthewMartin Nov 28 '11 at 18:49
yes Microsoft Analsis services has chaos isolation level –  user13108 Oct 2 '12 at 23:19

1 Answer 1

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.