Default Isolation Mode Property

Default Isolation Mode Property

SQL Server 2000

Default Isolation Mode Property

This property controls the default transaction level isolation mode, which can override the transaction level determined by the rowset cursor type.

Property Name

Default Isolation Mode

Property ID



If the first character of this string is Y, T, or a numeric digit other than 0 (zero), the isolation level is Serializable (also known as Isolated). Otherwise, the cursor type requested by the rowset determines the isolation level. For more information about isolation levels, see the OLE DB documentation.

Use this property to provide read repeatability.

This property's value is used when a session is established, and the value can be changed during the session.

© 2016 Microsoft