Database.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.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property SnapshotIsolationState As SnapshotIsolationState 
    Get
'Usage
Dim instance As Database 
Dim value As SnapshotIsolationState 

value = instance.SnapshotIsolationState
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public SnapshotIsolationState SnapshotIsolationState { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property SnapshotIsolationState SnapshotIsolationState {
    SnapshotIsolationState get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
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.

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Using Row Versioning-based Isolation Levels