Export (0) Print
Expand All
Expand Minimize

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

DBPROP_MSMD_DEFAULT_ISOLATION_MODE

Remarks

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.

Show:
© 2014 Microsoft