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.