DatabaseOptions.SnapshotIsolationState Property

Gets the snapshot isolation state for the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property SnapshotIsolationState As SnapshotIsolationState 
    Get
'Usage
Dim instance As DatabaseOptions 
Dim value As SnapshotIsolationState 

value = instance.SnapshotIsolationState

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public SnapshotIsolationState SnapshotIsolationState { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property SnapshotIsolationState SnapshotIsolationState {
    SnapshotIsolationState get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member SnapshotIsolationState : SnapshotIsolationState

function get SnapshotIsolationState () : SnapshotIsolationState

Property Value

Type: Microsoft.SqlServer.Management.Smo.SnapshotIsolationState
A SnapshotIsolationState object value that specifies the snapshot isolation state of the database.

Remarks

Snapshot isolation (or row-level versioning) is an isolation level in SQL Server.

Examples

Setting Properties

See Also

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Options