skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver : Connection Properties : SnapshotSerializable
  
SnapshotSerializable
Purpose
For Microsoft SQL Server 2005 and higher and Microsoft Windows Azure SQL Database only. Allows your application to use Snapshot Isolation for connections.
This property is useful for applications that have the Serializable isolation level set. Using the SnapshotSerializable property allows you to use Snapshot Isolation with no or minimum code changes. If you are developing a new application, you may find that using the constant TRANSACTION_SNAPSHOT is a better choice.
Valid Values
true | false
Behavior
If set to true and your application has the transaction isolation level set to Serializable, the application uses Snapshot Isolation for connections.
If set to false and your application has the transaction isolation level set to Serializable, the application uses the Serializable isolation level.
Notes
*To use Snapshot Isolation, your database also must be configured for Snapshot Isolation.
Default
false
Data Type
boolean
See also
Isolation Levels
Performance Considerations